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

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

效果图：

 

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

1. <table align="center" bgcolor="#c0de98"border="0" cellpadding="0" cellspacing="1"width="99%"> 
2. <tr> 
3. <thcolspan="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. usingSystem.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, EventArgse) 
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_Userwhere 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. }