asp.net GridView 删除时弹出确认对话框(包括内容提示)
asp.net GridView 删除时弹出确认对话框(包括内容提示)
发布时间:2016-12-29 来源:查字典编辑
摘要:效果图:html代码复制代码代码如下:GridView演示C#代码复制代码代码如下:usingSystem;usingSystem.Data...

效果图:

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

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" >

<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 + ""吗?')");

}

}

}

}

推荐文章
猜你喜欢
附近的人在看
推荐阅读
拓展阅读
相关阅读
网友关注
最新asp.net教程学习
热门asp.net教程学习
编程开发子分类