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

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