ASP.NET 例程完全代码版(5)——通过web.config配置数据库连接池

应用程序中这样读取即可：
    private readonly string SQLCONNECTIONSTRING = ConfigurationManager.ConnectionStrings["CONNSTRING"].ConnectionString;
下面是测试的例子，当然基本的ADO.NET连接数据库的知识要知道。
建立一个DbPooling.aspx，代码如下：

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class DbPooling : System.Web.UI.Page
{
    private readonly string SQLCONNECTIONSTRING = ConfigurationManager.ConnectionStrings["CONNSTRING"].ConnectionString;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            ConnectionObject();
            DataSet ds = null;
            for (int i = 0; i < 1000; i++)
            {
                ds = GetCustomers(true);    //true——配置连接池
            }
            GridView1.DataSource = ds;      //03中的DataGrid现在是GridView
            GridView1.DataBind();
        }
    }

    
    private DataSet GetCustomers(bool nStartPooling)
    {
        string connStr = SQLCONNECTIONSTRING + "Pooling=" + nStartPooling.ToString();   //通过传递的bool指定是否配置连接池
        Label1.Text = connStr;
        SqlConnection conn = new SqlConnection(connStr);
        string cmdText = "SELECT Top 10 * FROM Book";
        SqlDataAdapter da = new SqlDataAdapter(cmdText, conn);
        conn.Open();
        DataSet ds = new DataSet();
        da.Fill(ds);
        conn.Close();
        return ds;
    }

    private void ConnectionObject()
    {
        SqlConnection conn = new SqlConnection(SQLCONNECTIONSTRING);
        string cmdText = "SELECT Count(*) as BookCount FROM Book";
        SqlCommand comm = new SqlCommand(cmdText, conn);
        conn.Open();

        int result = (int)comm.ExecuteScalar();
        Response.Write("Book表的记录数为：" + result.ToString());
        Response.Write("<br>SQL Server数据库的连接状态为：" + conn.State.ToString());
        Response.Write("<br>SQL Server数据库连接的通信包的大小为：" + conn.PacketSize.ToString());
        Response.Write("<br>SQL Server数据库连接的数据库为：" + conn.Database.ToString());
        Response.Write("<br>SQL Server数据库连接的工作站点：" + conn.WorkstationId.ToString());
        conn.Close();
        Response.Write("<br>SQL Server数据库的连接状态：" + conn.State.ToString());

    }
}
      对于刚刚开始熟悉 VS2005 的朋友来说，很多细节的东西要与03区别，当然，查一下SDK很容易找到异同和解决方法，本文小例针对在05中初次配置web.config遇到的小麻烦做一总结，详细的 configuration 操作可以参考SDK了，呵呵。

本文转自 august 51CTO博客，原文链接：http://blog.51cto.com/august/6971，如需转载请自行联系原作者