在Web.config里怎么配置数据库连接池

Question

想用数据库连接池，怎么在 web.config 里配置？非常感谢。

Answer 1

可以这么配
<appSettings>
  <add key="strconn" value="数据库连接池" />
</appSettions>

Answer 2

<configuration>
    <connectionStrings>
        <add name="test" connectionString="Password=123;User ID=sa;database=databasename;Data Source=."/>
    </connectionStrings>
</configuration>

Answer 3

<configuration>
    <connectionStrings>
        <add name="test" connectionString="Password=数据库密码;User ID=登陆用户;database=数据库名称;Data Source=服务器电脑名称"/>
    </connectionStrings>
</configuration> 

Answer 4

http://www.connectionstrings.com

Answer 5

<connectionStrings>
    <add name="ConnectString" connectionString="server =localhost;Initial Catalog=数据库名;uid=sa;pwd=sa" providerName="System.Data.SqlClient" />
  </connectionStrings>

Answer 6

WEB.CONFIG
  <connectionStrings>
    <add name="sqlConnection" connectionString="Data Source=服务器名;Initial Catalog=数据库名;Persist Security Info=True;User ID=账号; Password=密码"   providerName="System.Data.SqlClient"/>  </connectionStrings>
后台得到
string sqlconn=ConfigurationManager.AppSettings["sqlConnection"];
楼主结贴吧

Answer 7

<connectionstrings>   <add name="ccopconnstr" connectionstring="data source=(local);pooling=true;max pool size=7500; min pool size=5;packet size=4096;initial catalog=ccop;user id=sa;password=wuaisheng;connection timeout=150;" providername="system.data.sqlclient"/>     </connectionstrings>