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

1 设置连接字符串

    <add name="SQLWebSiteConfigureConnString" connectionString="server=.;database=1228;user id=sa;password=123;min pool size=4;max pool size=4;"
     providerName="System.Data.SqlClient" />
    <add name="SQLMerchandiseConnString" connectionString="server=.;database=1228;user id=sa;password=123;min pool size=4;max pool size=4;"
     providerName="System.Data.SqlClient" />
    <add name="SQLNewsConnString" connectionString="server=.;database=1228;user id=sa;password=123;min pool size=4;max pool size=4;"
     providerName="System.Data.SqlClient" />
    <add name="SQLMemberConnString" connectionString="server=.;database=1228;user id=sa;password=123;min pool size=4;max pool size=4;"
     providerName="System.Data.SqlClient" />
    <add name="SQLOrdersConnString" connectionString="server=.;database=1228;user id=sa;password=123;min pool size=4;max pool size=4;"
     providerName="System.Data.SqlClient" />
    <add name="SQLCompanyConnString" connectionString="server=.;database=1228;user id=sa;password=123;max pool size=4;min pool size=4;"
     providerName="System.Data.SqlClient" />
    <add name="SQLInventoryConnString" connectionString="server=.;database=1228;user id=sa;password=123;min pool size=4;max pool size=4;"
     providerName="System.Data.SqlClient" />
    <add name="SQLItelligentQAConnString" connectionString="server=.;database=smartAnswer;user id=sa;password=123;min pool size=4;max pool size=4;"
     providerName="System.Data.SqlClient" />

 

2 设置mode的属性，如果用SA登陆的话为"Forms"

    <authentication mode="Forms">
      <forms loginUrl="/login2.aspx" protection="All" timeout="12000">
        <credentials passwordFormat="SHA1">
          <user name="keede" password="DFAAE4616403A90F65BF7BC5AF95EB5FD719717A"/>
          <user name="admin" password="A4CBB2F3933C5016DA7E83FD135AB8A48B67BF61"/>
          <user name="aaa" password="5CB138284D431ABD6A053A56625EC088BFB88912"/>
        </credentials>
      </forms>
    </authentication>