web.config
<connectionstrings> <add name="testConnectionString" connectionstring="Data Source=PC\SQLEXPRESS;Initial Catalog=test;Persist Security Info=True;User ID=sa;Password=123"> providerName="System.Data.SqlClient" /> </add></connectionstrings>
string conn = ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(conn)) { con.Open(); } or using (SqlConnection con = new SqlConnection(@"Data Source=PC\SQLEXPRESS;Initial Catalog=test;Persist Security Info=True;User ID=sa;Password=123")) { con.Open(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)