JADE JADE - 20 days ago 12
Vb.net Question

How to read <connectionstring> of web.config from a console application?

I have VB.net console application. I would like to read the (ConnectionString) from a web.config.

Web.config
is located at a particular path in my virtual PC, say "C:/mywebConfig"

<add name="MY_DB" connectionString="Data Source=DATASOURCE;Initial Catalog=DB;Persist

Security Info=False; User ID=***;Password=****;" providerName="System.Data.SqlClient" />


My code:

Dim connString As String = String.Empty

connString = ConfigurationManager.ConnectionStrings("MY_DB").ConnectionString


Whenever I try to access it, i get the error not set to an instance of an object or something like that :)

Help please.

I tried to add the web.config in my Project, but still get the error.

Answer

As Matt suggested for a console app you need to include a app.config file instead. For easy reading of that file you can reference the System.Configuration assembly and then use the System.Configuration.ConfigurationManager.ConnectionStrings property.

For example:

string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["dbconnectionString"].ConnectionString;

EDIT

I've just re-read your post and it might be a good idea to check your app has permission to read .config files from the c:\ drive.

Comments