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

}