asp.net GridView 删除时弹出确认…

GridView 删除时弹出确认对话框(包括内容提示)

效果图：

 

html代码
复制代码 代码如下:

1. <table align="center" bgcolor="#c0de98" border="0" cellpadding="0" cellspacing="1" width="99%"> 
2. <tr> 
3. <th colspan="2"> 
4. GridView演示</th> 
5. </tr> 
6. <tr> 
7. <td colspan="2" style="width: 100%;" > 
8. <asp:GridView ID="GridView" runat="server" Width="100%" AllowPaging="True" OnPageIndexChanging="GridView_PageIndexChanging" PageSize="12" OnRowDeleting="GridView_RowDeleting" OnRowDataBound="GridView_RowDataBound" > 
9. <Columns> 
10. <asp:BoundField DataField="UserID" HeaderText="UserID" ReadOnly="True" /> 
11. <asp:BoundField DataField="C_Name" HeaderText="中文名字" ReadOnly="True" /> 
12. <asp:BoundField DataField="E_Name" HeaderText="英文名字" ReadOnly="True" /> 
13. <asp:BoundField DataField="QQ" HeaderText="QQ帐号" /> 
14. <asp:CommandField HeaderText="删除" ShowDeleteButton="True" /> 
15. </Columns> 
16. <RowStyle HorizontalAlign="Center" /> 
17. <PagerStyle HorizontalAlign="Right" /> 
18. </asp:GridView> 
19. </td> 
20. </tr> 
21. </table>

C#代码
复制代码 代码如下:

1. using System; 
2. using System.Data; 
3. using System.Data.SqlClient; 
4. using System.Configuration; 
5. using System.Collections; 
6. using System.Web; 
7. using System.Web.Security; 
8. using System.Web.UI; 
9. using System.Web.UI.WebControls; 
10. using System.Web.UI.WebControls.WebParts; 
11. using System.Web.UI.HtmlControls;
12. public partial class Demo11 : System.Web.UI.Page 
13. { 
14. protected void Page_Load(object sender, EventArgs e) 
15. { 
16. if (Page.IsPostBack == false) 
17. { 
18. BindData(); 
19. } 
20. }
21. public void BindData() 
22. { 
23. string strSql = "select UserID,C_Name,E_Name,QQ from Demo_User "; 
24. DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.CONN_STRING, CommandType.Text, strSql, null).Tables[0];
25. GridView.DataSource = dt; 
26. GridView.DataKeyNames = new string[] { "UserID" };//设置主键 
27. GridView.DataBind(); 
28. }
29. protected void GridView_PageIndexChanging(object sender, GridViewPageEventArgs e) 
30. { 
31. GridView.PageIndex = e.NewPageIndex; 
32. BindData(); 
33. }
34. protected void GridView_RowDeleting(object sender, GridViewDeleteEventArgs e) 
35. { 
36. int UserID = (int)GridView.DataKeys[e.RowIndex].Value; //取得主键
37. string strSql = "Delete Demo_User where UserID=@UserID"; 
38. SqlParameter[] para = { 
39. new SqlParameter("@UserID", UserID), 
40. }; 
41. SqlHelper.ExecuteNonQuery(SqlHelper.CONN_STRING, CommandType.Text, strSql, para); 
42. BindData(); 
43. }
44. protected void GridView_RowDataBound(object sender, GridViewRowEventArgs e) 
45. { 
46. if (e.Row.RowType == DataControlRowType.DataRow) 
47. { 
48. if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate) 
49. { 
50. ((LinkButton)e.Row.Cells[4].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除：\"" + e.Row.Cells[1].Text + "\"吗?')"); 
51. } 
52. } 
53. } 
54. }