CODEWITHSUNDEEP
.netvb.netweb-configconnection-stringapp-config
JADE
JADE

Reputation: 523

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.

Upvotes: 2

Views: 12347

Answers (3)

Arnout
Arnout

Reputation: 2790

If you do indeed want to read the app.config or web.config of another (web) app, take a look at ConfigurationManager.OpenMappedExeConfiguration.

Upvotes: 2

Mike
Mike

Reputation: 671

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.

Upvotes: 0

Matt Wilko
Matt Wilko

Reputation: 27322

web.config is used for web applications - you will need a app.config file.

Have a look at this link for the differences:

dotNET - app.config and web.config

Also this stack overflow question what is app.config for

Upvotes: 0

Related Questions