在web.config中设置数据库连接字符串配置

Question

 <connectionStrings>
    <!--t-->
    <add name="ConnectionString" connectionString="Provider=SQLOLEDB.1;
       Password=sa;Persist Security Info=True;
       User ID=sa;Initial Catalog=ST_EnterpriseOnlineInfoManage;
       Data Source=(local);"/>
  </connectionStrings>
在windows验证模式下如何修改

Answer 1

<connectionStrings>
  <!--t-->
  <add name="ConnectionString" connectionString="Provider=SQLOLEDB.1;
  Integrated Security=True;Initial Catalog=ST_EnterpriseOnlineInfoManage;
  Data Source=(local);"/>
  </connectionStrings>

Answer 2

<connectionStrings>
  <add name="ConnectionString" connectionString="Data Source=数据库服务器名称或IP地址;Initial Catalog=数据库名称;Persist Security Info=True;User ID=sa;Password=sa;MultipleActiveResultSets=True;"
  providerName="System.Data.SqlClient" />
 </connectionStrings>