连接ms sql数据库写法

windows 集成验证：
<connectionStrings>
   <add name="ConnectionStr" connectionString="Data Source=CAIPENG-PC;database=Test;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>
  </connectionStrings>
或者
<connectionStrings>
<add name="ConnectionStr" connectionString="Data Source=CAIPENG-PC;Initial Catalog=Test;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
混合验证：
<connectionStrings>
      <add name="ConnectionStr" connectionString="Data Source=CAIPENG-PC;Initial Catalog=Test;uid=sa;pwd=caipeng" providerName="System.Data.SqlClient"/>
  </connectionStrings>
取ConnectionStr：
string conn=System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionStr"].ConnectionString;