Asp.net GridView添加删除确认和自动编号代码

 

2009-02-24 00:00

一、在GridView中添加删除确认对话框 实现方法： 双击GridView的OnRowDataBound事件； 在后台的GridView1_RowDataBound()方法添加代码，最后代码如下所示：     protected void GridView1_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[6].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除：" + e.Row.Cells[1].Text.Trim() + "吗?')");             }         }     } 另一种方法： 在GridView的RowCommand事件中添加代码 protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)     {         if (e.Row.RowType == DataControlRowType.DataRow)         {             if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)             {                            LinkButton btnDelete = (LinkButton)e.Row.FindControl("LinkButton1");              btnDelete.Attributes.Add("onclick", "Javascript:return " +"confirm('Are you sure you want to delete this record " +DataBinder.Eval(e.Row.DataItem, "NewsTitle") + "')");             }         }     } protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e)     {         oa jkj=new oa();         GridViewRow dr = GridView2.Rows[e.RowIndex];         string id = dr.Cells[1].Text;         string sql = "Delete from news where newsid=" +id ;         jkj.Command(sql);//自定义类         Bind();     } 二、实现自动编号的方法 双击GridView的OnRowDataBound事件； 在后台的GridView1_RowDataBound()方法添加代码，最后代码如下所示：     protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)     {         //如果是绑定数据行         if (e.Row.RowType == DataControlRowType.DataRow)         {             鼠标经过时，行背景色变             //e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#E6F5FA'");             鼠标移出时，行背景色变             //e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFFFFF'");             当有编辑列时，避免出错，要加的RowState判断             //if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)             //{             //    ((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除：" + e.Row.Cells[1].Text.Trim() + "吗?')");             //}         }         if (e.Row.RowIndex != -1)         {             int id = e.Row.RowIndex + 1;             e.Row.Cells[0].Text = id.ToString();         }     } 注意这时最好把前台的第一列的表头该为“编号”，因为以前的第一列被“吃掉”了。 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="3" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing"                         OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Font-Size="12px" OnRowDataBound="GridView1_RowDataBound">                         <FooterStyle BackColor="White" ForeColor="#000066" />                         <Columns>                             <asp:BoundField DataField="身份证号码" HeaderText="编号" ReadOnly="True" />                             <asp:BoundField DataField="姓名" HeaderText="用户姓名" />                             <asp:BoundField DataField="员工性别" HeaderText="性别" />                             <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" />                             <asp:CommandField HeaderText="选择" ShowSelectButton="True" />                             <asp:CommandField HeaderText="编辑" ShowEditButton="True" />                             <asp:CommandField HeaderText="删除" ShowDeleteButton="True" />                         </Columns>                         <RowStyle ForeColor="#000066" />                         <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />                         <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />                         <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />                     </asp:GridView>

转载于:https://www.cnblogs.com/jiayongmao/archive/2009/05/05/1449695.html