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 4532 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;

Leave a Comment


x

You might be Interested in these Posts

How to decode a base64 string in C#?

Here's a sample code snippet demonstrating how you can easily decode a base64 encoded string in C#. ...

How to disable editing of items in a combo box in c#?

When working in Win forms using C# and especially when you use the combo box , you would have notice...

C# Program to find the ASCII Value of a Character

Problem Write a program in Visual C# to find the ASCII value of the input character. How to find t...