很多时候，我们都会习惯将数据库连接的初始化过程交给Page_Load去做，其实这样子有好处也有坏处，好处是单边问题的时候，这种方法很实用，坏处就是遇到多边的问题时，就种情况这不太好用了！例如下面的例子：
/// For Example:
1<script language="C#" runat="server">
2SqlConnection mySqlCon;
3protected void Page_Load(Object Src,EventArgs E)
4{
5mySqlCon=new SqlConnection("server=localhost;uid=sa;pwd=sa;database=pubs"); //初始化过程
6if (!IsPostBack)
7BindGrid();
8}
9public void AddPublisher(Object sender, EventArgs E)
10{
11String myinsertCmd = "insert into publishers ( pub_id, pub_name, city, state, country ) values (@pubid,@pubname,@city,@state,@country)";
12SqlCommand mySqlCom = new SqlCommand(myinsertCmd, mySqlCon); //初始化命令调用
13//实现配套
14mySqlCom.Parameters.Add(new SqlParameter("@pubid", SqlDbType.Char, 4));
15mySqlCom.Parameters["@pubid"].Value = Pub_Id.Text;
16mySqlCom.Parameters.Add(new SqlParameter("@pubname", SqlDbType.VarChar, 40));
17mySqlCom.Parameters["@pubname"].Value = Pub_Name.Text;
18mySqlCom.Parameters.Add(new SqlParameter("@city", SqlDbType.VarChar, 20));
19mySqlCom.Parameters["@city"].Value = City.Text;
20mySqlCom.Parameters.Add(new SqlParameter("@state", SqlDbType.Char, 2));
21mySqlCom.Parameters["@state"].Value = State.Text;
22mySqlCom.Parameters.Add(new SqlParameter("@country",SqlDbType.VarChar, 30));
23mySqlCom.Parameters["@country"].Value = Country.Text;
24//打开DB
25mySqlCom.Connection.Open();
26mySqlCom.ExecuteNonQuery();
27Message.InnerHtml = "<b>已添加记录</b>
28";
29mySqlCom.Connection.Close();
30Pub_Id.Text = "";
31Pub_Name.Text = "";
32City.Text= "";
33State.Text = "";
34Country.Text = "";
35BindGrid();
36}
37//子函数调用
38public void BindGrid()
39{
40SqlDataAdapter mySqlCom = new SqlDataAdapter("select * from publishers where pub_id like '99%'", mySqlCon);
41DataSet myds = new DataSet();
42mySqlCom.Fill(myds, "publishers");
43dgMyGrid.DataSource = myds.Tables["publishers"].DefaultView; dgMyGrid.DataBind();
44}
45</script>
1<h2>添加一个新的发行者：</h2>
发行者 ID 应以 99 打头，并包含 4 位数字
发行者 ID：
1<asp:textbox id="Pub_Id" runat="server"></asp:textbox>
姓名：
1<asp:textbox id="Pub_Name" runat="server"></asp:textbox>
城市：
1<asp:textbox id="City" runat="server"></asp:textbox>
省：
1<asp:textbox id="State" runat="server"></asp:textbox>
国家：
1<asp:textbox id="Country" runat="server"></asp:textbox>
1<asp:button id="Button1" onclick="AddPublisher" runat="server" text="提交"></asp:button>
1<span id="Message" runat="server"></span>
1<asp:datagrid id="dgMyGrid" runat="server"></asp:datagrid>
这样的例子初初看起来没有问题，调试也没报错，但在生成的页面添加数据后提交时就会报错，说什么属性不配套之类的话。是什么原因造成的呢！其实，这就是初始化过程在页面装载时造成的，但这里有个问题我始终没能搞清楚，就是既然是在页面初始化过程已经初始化过DB实例了，按道理来讲应该可以直接生成套用的啊，但好像没有！还是要把初始化过程放到具体的函数里面才能实现！看下面:
<
1<script language="C#" runat="server">
2
3protected void Page_Load(Object Src,EventArgs E)
4{
5//页面装载过程中直接使用IF语句，其实什么也不加！
6if (!IsPostBack)
7BindGrid();
8}
9public void AddPublisher(Object sender, EventArgs E)
10{
11string strprovider="server=localhost;uid=sa;pwd=sa;database=pubs"; //构造初始化过程
12SqlConnection mySqlCon=new SqlConnection(strprovider);
13string myinsertCmd ="insert into publishers ( pub_id, pub_name, city, state, country ) values (@pubid,@pubname,@city,@state,@country)";
14SqlCommand mySqlCom = new SqlCommand(myinsertCmd,mySqlCon); //初始化过程实现
15mySqlCom.Parameters.Add(new SqlParameter("@pubid", SqlDbType.Char, 4));
16mySqlCom.Parameters["@pubid"].Value = Pub_Id.Text;
17mySqlCom.Parameters.Add(new SqlParameter("@pubname", SqlDbType.VarChar, 40));
18mySqlCom.Parameters["@pubname"].Value = Pub_Name.Text;
19mySqlCom.Parameters.Add(new SqlParameter("@city", SqlDbType.VarChar, 20));
20mySqlCom.Parameters["@city"].Value = City.Text;
21mySqlCom.Parameters.Add(new SqlParameter("@state", SqlDbType.Char, 2));
22mySqlCom.Parameters["@state"].Value = State.Text;
23mySqlCom.Parameters.Add(new SqlParameter("@country",SqlDbType.VarChar, 30));
24mySqlCom.Parameters["@country"].Value = Country.Text;
25mySqlCom.Connection.Open();
26mySqlCom.ExecuteNonQuery();
27Message.InnerHtml = "<b>已添加记录</b><br>";
28mySqlCom.Connection.Close();
29Pub_Id.Text = "";
30Pub_Name.Text = "";
31City.Text= "";
32State.Text = "";
33Country.Text = "";
34BindGrid();
35}
36public void BindGrid() 子函数调用时同样也要初始化DB连接
37{
38string strprovider="server=dev;uid=sa;pwd=pauperboyboy;database=pubs";
39SqlConnection mySqlCon=new SqlConnection(strprovider);
40SqlDataAdapter mySqlCom = new SqlDataAdapter("select * from publishers where pub_id like '99%'",mySqlCon);
41DataSet myds = new DataSet();
42mySqlCom.Fill(myds, "publishers");
43dgMyGrid.DataSource = myds.Tables["publishers"].DefaultView;
44dgMyGrid.DataBind();
45}
46</script>
1<h2>添加一个新的发行者：</h2>
1<br/>
发行者 ID 应以 99 打头，并包含 4 位数字
1<br/>
发行者 ID：
1<asp:textbox id="Pub_Id" runat="server"></asp:textbox>
姓名：
1<asp:textbox id="Pub_Name" runat="server"></asp:textbox>
城市：
1<asp:textbox id="City" runat="server"></asp:textbox>
1<br/>
省：
1<asp:textbox id="State" runat="server"></asp:textbox>
国家：
1<asp:textbox id="Country" runat="server"></asp:textbox>
1<br/>
1<br/>
1<asp:button id="Button1" onclick="AddPublisher" runat="server" text="提交"></asp:button>
1<br/>
1<span id="Message" runat="server"></span>
1<br/>
1<asp:datagrid id="dgMyGrid" runat="server"></asp:datagrid>
>
经过这样修改后，我们才能在真正意义上实现数据的增加！但我也试了数据的删除和更新，在页面装载时直接赋于其初始化DB属性却没有问题，不知道是什么原因，知道的人给提个醒哦！谢谢 :)