连接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;