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 2330 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.
    ConnectionStrings["connection1"].ConnectionString;
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


x

You might be Interested in these Posts

C++ Program to display "Hello, World!"

Problem Write a program in C++ to display "Hello, World!" on the screen. C++ Program to...

How to return Json instead of XML in ASP.NET Web API ?

When you make a call to the ASP.NET Web API action method and notice this in Google Chrome browser ,...

How to Add Web API to existing ASP.NET Web Forms Project ?

In one of the previous posts , we saw how to add the WebAPI to the existing ASP.NET MVC project. Wel...