1.集成的windows验证
string constr = "server=.;database=myschool;integrated security=SSPI";
2.SqlServer身份验证
string constr = "data source=.;initial catalog=myschool;user id=sa;pwd=sa";
web.config配置
<connectionStrings>
<add name="mysql" connectionString="Server=localhost;Integrated Security=True;Database=myschool;Persist Security Info=True" providerName="System.Data.SqlClient">
</connectionString>
在C#中连接的语句
public static string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["mysql"].ToString();