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

  效果图:

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

  html代码

  

复制代码 代码如下:

  <table align="center" bgcolor="#c0de98" border="0" cellpadding="0" cellspacing="1" width="99%">

  <tr>

  <th colspan="2">

  GridView演示</th>

  </tr>

  <tr>

  <td colspan="2" style="width: 100%;" >

  <asp:GridView ID="GridView" runat="server" Width="100%" AutoGenerateColumns="False" AllowPaging="True" OnPageIndexChanging="GridView_PageIndexChanging" PageSize="12" OnRowDeleting="GridView_RowDeleting" OnRowDataBound="GridView_RowDataBound" >

  <Columns>

  <asp:BoundField DataField="UserID" HeaderText="UserID" ReadOnly="True" />

  <asp:BoundField DataField="C_Name" HeaderText="中文名字" ReadOnly="True" />

  <asp:BoundField DataField="E_Name" HeaderText="英文名字" ReadOnly="True" />

  <asp:BoundField DataField="QQ" HeaderText="QQ帐号" />

  <asp:CommandField HeaderText="删除" ShowDeleteButton="True" />

  </Columns>

  <RowStyle HorizontalAlign="Center" />

  <PagerStyle HorizontalAlign="Right" />

  </asp:GridView>

  </td>

  </tr>

  </table>

  C#代码

  

复制代码 代码如下:

  using System;

  using System.Data;

  using System.Data.SqlClient;

  using System.Configuration;

  using System.Collections;

  using System.Web;

  using System.Web.Security;

  using System.Web.UI;

  using System.Web.UI.WebControls;

  using System.Web.UI.WebControls.WebParts;

  using System.Web.UI.HtmlControls;

  public partial class Demo11 : System.Web.UI.Page

  {

  protected void Page_Load(object sender, EventArgs e)

  {

  if (Page.IsPostBack == false)

  {

  BindData();

  }

  }

  public void BindData()

  {

  string strSql = "select UserID,C_Name,E_Name,QQ from Demo_User ";

  DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.CONN_STRING, CommandType.Text, strSql, null).Tables[0];

  GridView.DataSource = dt;

  GridView.DataKeyNames = new string[] { "UserID" };//主键

  GridView.DataBind();

  }

  protected void GridView_PageIndexChanging(object sender, GridViewPageEventArgs e)

  {

  GridView.PageIndex = e.NewPageIndex;

  BindData();

  }

  protected void GridView_RowDeleting(object sender, GridViewDeleteEventArgs e)

  {

  int UserID = (int)GridView.DataKeys[e.RowIndex].Value;

  string strSql = "Delete Demo_User where UserID=@UserID";

  SqlParameter[] para = {

  new SqlParameter("@UserID", UserID),

  };

  SqlHelper.ExecuteNonQuery(SqlHelper.CONN_STRING, CommandType.Text, strSql, para);

  BindData();

  }

  protected void GridView_RowDataBound(object sender, GridViewRowEventArgs e)

  {

  if (e.Row.RowType == DataControlRowType.DataRow)

  {

  if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)

  {

  ((LinkButton)e.Row.Cells[4].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除:\"" + e.Row.Cells[1].Text + "\"吗?')");

  }

  }

  }

  }