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

[乐于编程]

想用数据库连接池，怎么在 web.config 里配置？

非常感谢。

[回头是岸]

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

[pz25925]

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

[xieyonjie]

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

[xieyonjie]

可以用VS 手动创建连接池 然后把链接地址复制进来就可以呢.

[dalmeeme]

http://www.connectionstrings.com

[m0708q]

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

[xiaofei52059487]

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"];
楼主结贴吧

[zhenglianghui]

<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>