1
private 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
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
浙公网安备 33010602011771号