How to read a connection string from web.config file in ASP.NET ?

Published on September 8, 2016 by abundantcode

Filed under ASP.NET, C#

Last modified September 8, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 659 times

Assume that you have a connectionstring configured in the web.config file of your ASP.NET application and you wish to read it using C# within your application.

How to read a connection string from web.config file in ASP.NET ?

You can easily do that using the ConfigurationManager class defined in the System.Configuration namespace.

1. Ensure that the System.Configuration assembly is referenced in your project.

2. Add the using directive in your code to import the namespace.

3. Retreive the connection string from the web.config using the System.Configuration.ConfigurationManager.
    ConnectionStrings option as shown

var connectionStr = System.Configuration.ConfigurationManager.
If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment


You might be Interested in these Posts

How to get the CommandLine of the Current Application in C# ?

You might need to get the information that contains the commandline which is used to execute the cur...

How to Generate C# class from a XML file ?

Do you want to generate C# class from an XML file ?. You can use the xsd tool to do it. How to Gene...

How to get the Names of all the columns from a SqlDataReader object in C# ?

Here's a simple code snippet that demonstrates how to retreive all the column names from a SqlDataRe...