Connection strings in web.config file using asp.net
1. Connection string for userid and password
<connectionStrings>
<add name=”ConnectinstringName” connectionString=”Data Source= DatabaseServerName; Integrated Security=true;Initial Catalog= YourDatabaseName; User ID=YourUserName;Password=yourpassword; ” providerName=”System.Data.SqlClient”/>
</connectionStrings >
2. Connection string for integrated security
<connectionStrings>
<add name=”ConnectinstringName” connectionString=”Data Source=Abdul;Integrated Security=true;Initial Catalog=DB” providerName=”System.Data.SqlClient”/>
</connectionStrings >
3. Add Namespace in Codebehind file
using System.Configuration;
4. Add this to page load
string strcon = ConfigurationManager.ConnectionStrings[“ConnectinstringName“].ConnectionString;
SqlConnection con = new SqlConnection(strcon);
con.Open();
