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
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)
string connString = ConfigurationSettings.AppSettings("ConnString");
2) Connection string in .NET 3.5 (web.config)
string connString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
Microsoft Visual Studio
<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