GridView实现数据编辑和删除
<asp:GridView ID="gv_Emplogin" runat="server" AutoGenerateColumns="False" |
02 |
onrowdeleting="gv_Emplogin_RowDeleting" |
03 |
onrowupdating="gv_Emplogin_RowUpdating" |
04 |
onrowediting="gv_Emplogin_RowEditing" |
05 |
onrowcancelingedit="gv_Emplogin_RowCancelingEdit"> |
06 |
<Columns> |
07 |
<asp:BoundField DataField="Emp_id" HeaderText="用户号" ReadOnly="True" /> |
08 |
<asp:BoundField DataField="Emp_name" HeaderText="登录名" /> |
09 |
<asp:BoundField DataField="Password" HeaderText="密码" /> |
10 |
<asp:BoundField DataField="name" HeaderText="姓名" /> |
11 |
<asp:BoundField DataField="Email" HeaderText="Email" /> |
12 |
<asp:BoundField DataField="Jb" HeaderText="用户类型" /> |
13 |
<asp:BoundField DataField="Tell" HeaderText="联系电话" /> |
14 |
|
15 |
<asp:CommandField ShowEditButton="True" /> //编辑 |
16 |
<asp:CommandField ShowDeleteButton="True" /> //删除 |
17 |
</Columns> |
18 |
|
19 |
</asp:GridView> |
后台代码：
01 |
/// <summary> |
02 |
/// GridView的绑定 |
03 |
/// </summary> |
04 |
public void Emplogin_Bind() |
05 |
{ |
06 |
this.gv_Emplogin.DataSource = em.EmploginInfo(); |
07 |
this.gv_Emplogin.DataBind(); |
08 |
} |
09 |
10 |
/// <summary> |
11 |
/// GridView的删除事件 |
12 |
/// </summary> |
13 |
/// <param name="sender"></param> |
14 |
/// <param name="e"></param> |
15 |
protected void gv_Emplogin_RowDeleting(object sender, GridViewDeleteEventArgs e) |
16 |
{ |
17 |
int Emp_id=int.Parse(gv_Emplogin.Rows[e.RowIndex].Cells[0].Text); |
18 |
if (em.Del_EmploginInfo(Emp_id) == 1) |
19 |
{ |
20 |
Emplogin_Bind(); |
21 |
} |
22 |
} |
23 |
24 |
/// <summary> |
25 |
/// GridView的编辑事件 |
26 |
/// </summary> |
27 |
/// <param name="sender"></param> |
28 |
/// <param name="e"></param> |
29 |
protected void gv_Emplogin_RowEditing(object sender, GridViewEditEventArgs e) |
30 |
{ |
31 |
gv_Emplogin.EditIndex=e.NewEditIndex; |
32 |
|
33 |
} |
34 |
35 |
/// <summary> |
36 |
/// GridView的更新事件 |
37 |
/// </summary> |
38 |
/// <param name="sender"></param> |
39 |
/// <param name="e"></param> |
40 |
protected void gv_Emplogin_RowUpdating(object sender, GridViewUpdateEventArgs e) |
41 |
{ |
42 |
int Emp_id=int.Parse(gv_Emplogin.Rows[e.RowIndex].Cells[0].Text); |
43 |
EmployeeInfo ei = new EmployeeInfo(); |
44 |
ei.Emp_name = ((TextBox)(gv_Emplogin.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim(); |
45 |
ei.Pwd = ((TextBox)(gv_Emplogin.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim(); |
46 |
ei.Name = ((TextBox)(gv_Emplogin.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim(); |
47 |
ei.Email = ((TextBox)(gv_Emplogin.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim(); |
48 |
ei.Jb = int.Parse(((TextBox)(gv_Emplogin.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim()); |
49 |
ei.Tell = ((TextBox)(gv_Emplogin.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim(); |
50 |
if (em.Update_EmploginInfo(ei,Emp_id) == 1) |
51 |
{ |
52 |
gv_Emplogin.EditIndex = -1; |
53 |
Emplogin_Bind(); |
54 |
} |
55 |
} |
56 |
57 |
/// <summary> |
58 |
/// GridView取消编辑事件 |
59 |
/// </summary> |
60 |
/// <param name="sender"></param> |
61 |
/// <param name="e"></param> |
62 |
protected void gv_Emplogin_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) |
63 |
{ |
64 |
gv_Emplogin.EditIndex = -1; |
65 |
Emplogin_Bind(); |
66 |
} |
