Web.configDB配置

  <connectionStrings/>

    <connectionStrings> 

    移除已有配置文件               

    <remove name="LocalSqlServer"/>  

    定义新的配置路径         

    <add name="LocalSqlServer"                

      connectionString="Data Source=Localhost;Integrated Security=SSPI;

       UID=Temp;PWD=123;Initial Catalog=ASPNETDB;"

      providerName="System.Data.SqlClient"/>

  </connectionStrings>

 

 

DB和ASP服务器在同一台机器的时候

     Integrated Security=SSPI;

 

 

DB和ASP在不同机器时候

     Integrated Security=SSPI;UID=Temp;PWD=123;