1private void dgPagerDel_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
2 {
3 int empID = (int)dgPagerDel.DataKeys[e.Item.ItemIndex];
4 string sqlCom = "delete Employees where EmployeeID="+empID.ToString();
5 //定义数据连接对象,其中数据库连接字符串是在Web.Config文件中定义的
6 SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionSqlServer"].ToString());
7 //定义命令对象
8 SqlCommand cmd = new SqlCommand(sqlCom,conn);
9 //打开数据连接
10 conn.Open();
11 try
12 {
13 //执行SQL命令
14 cmd.ExecuteNonQuery();
15 //取得当前页的索引
16 lastEditedPage = dgPagerDel.CurrentPageIndex;
17 //如果有多页并且当前页中的项数仅有一项
18 if ((dgPagerDel.PageCount - dgPagerDel.CurrentPageIndex) == 1 && dgPagerDel.Items.Count == 1)
19 {
20 if (dgPagerDel.PageCount > 1)
21 {
22 lastEditedPage = lastEditedPage - 1;
23 }
24 else
25 {
26 lastEditedPage = 0;
27 }
28 }
29 dgPagerDel.CurrentPageIndex = lastEditedPage;
30 DataGridDataBind();
31 }
32 catch(SqlException err)
33 {
34 //输出异常信息
35 Response.Write(err.ToString());
36 }
37 finally
38 {
39 //关闭连接对象
40 conn.Close();
41 }
42 }
43
2 {
3 int empID = (int)dgPagerDel.DataKeys[e.Item.ItemIndex];
4 string sqlCom = "delete Employees where EmployeeID="+empID.ToString();
5 //定义数据连接对象,其中数据库连接字符串是在Web.Config文件中定义的
6 SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionSqlServer"].ToString());
7 //定义命令对象
8 SqlCommand cmd = new SqlCommand(sqlCom,conn);
9 //打开数据连接
10 conn.Open();
11 try
12 {
13 //执行SQL命令
14 cmd.ExecuteNonQuery();
15 //取得当前页的索引
16 lastEditedPage = dgPagerDel.CurrentPageIndex;
17 //如果有多页并且当前页中的项数仅有一项
18 if ((dgPagerDel.PageCount - dgPagerDel.CurrentPageIndex) == 1 && dgPagerDel.Items.Count == 1)
19 {
20 if (dgPagerDel.PageCount > 1)
21 {
22 lastEditedPage = lastEditedPage - 1;
23 }
24 else
25 {
26 lastEditedPage = 0;
27 }
28 }
29 dgPagerDel.CurrentPageIndex = lastEditedPage;
30 DataGridDataBind();
31 }
32 catch(SqlException err)
33 {
34 //输出异常信息
35 Response.Write(err.ToString());
36 }
37 finally
38 {
39 //关闭连接对象
40 conn.Close();
41 }
42 }
43