Storing connection string in web.config Asp.Net

Storing connection string in web.config Asp.Net

In both cases use System.Configuration;
You can get your connection string by using UDL file like here: Basic database connection string

1) Connection string in .NET 2.0 (web.config)

<appSettings>
<add key="ConnString" value="Integrated Security=SSPI;Persist Security Info=False;
Initial Catalog=tests;Data Source=MAK-PC\MSSQLSERVER2008" />
</appSettings>

Use (C#):
string connString = ConfigurationSettings.AppSettings("ConnString");

2) Connection string in .NET 3.5 (web.config)

<connectionStrings>
<add name="ConnString" connectionString="Integrated Security=SSPI;Persist Security Info=False;
Initial Catalog=tests;Data Source=MAK-PC\MSSQLSERVER2008" />
</connectionStrings>

Use (C#):
string connString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;

Microsoft Visual Studio