ASP.NET Gridview 中使用checkbox删除的2种方法实例分享

方法一：
后台代码：

 protected void btn_delete_click(object sender, eventargs e)
    {
        for (int i = 0; i <this.gridview1.rows.count; i++)
        {
            int id = convert.toint32(this.gridview1.datakeys[i].value);
            if ((this.gridview1.rows[i].cells[0].findcontrol("checkbox1") as checkbox).checked == true)
            {
                delete(id);
                clientscript.registerstartupscript(gettype(),"提示","<script>alert('删除成功！')</script>");
            }
        }
        this.gridview1.databind();
    }//删除
    private void delete(int id)
    {
        using (sqlconnection conn = new sqlconnection(str))
        {
            conn.open();
            sqlcommand comm = conn.createcommand();
            comm.commandtext = "delete from notice_msg where id=@id";
            comm.parameters.add(new sqlparameter("@id", id));
            comm.executenonquery();
        }
    }

前台代码：

<asp:gridview id="gridview1" runat="server" datakeynames="id">

另外还得添加一列，让其绑定的字段为id，并且把这一列的visable属性设为false
方法二：
后台：

 protected void btn_delete_click(object sender, eventargs e)
    {
        foreach (gridviewrow row in this.gridview1.rows)
        {
            if (row.rowtype == datacontrolrowtype.datarow)
            {
                checkbox ckb = row.cells[2].findcontrol("checkbox1") as checkbox;
                if (ckb.checked)
                {
                    using (sqlconnection sqlcnn = new sqlconnection(str))
                    {
                        using (sqlcommand sqlcmm = sqlcnn.createcommand())
                        {
                            sqlcmm.commandtext = "delete from regime_table where id='" + row.cells[0].text + "' ";
                            sqlcnn.open();
                            int a= sqlcmm.executenonquery();
                            if (a>0)
                            {
                                clientscript.registerstartupscript(gettype(),"提示","<script>alert('删除成功！')</script>");
                            }
                            else
                            {
                                clientscript.registerstartupscript(gettype(), "提示", "<script>alert('删除失败！')</script>");
                            }
                            this.databind();
                        }
                    }
                }
            }
        }
    }

前台：

<style type="text/css">
    .hidden
    {
        display:none;
    }
    </style>
<asp:boundfield datafield="id" headertext="编号" >
                   <headerstyle cssclass="hidden" />
                   <itemstyle cssclass="hidden" />
                   </asp:boundfield>

新增加一列，这一列绑定id字段，并且visable属性不能为false,否则取不出值来。

checkbox全选功能：

<script type="text/jscript">
         function change(sender) {
             var table = document.getelementbyid("gridview1");
             for (var i = 1; i < table.rows.length; i++) {
                 table.rows[i].cells[1].getelementsbytagname("input")[0].checked = sender.checked;
             }
         }
    </script>
<headertemplate>
      <input id="checkbox2" type="checkbox" onclick="change(this)"/>
             全选
         </headertemplate>