GridView全选并删除所有列的问题

最新推荐文章于 2020-11-01 19:42:47 发布

deltazxm

最新推荐文章于 2020-11-01 19:42:47 发布

阅读量1.1k

点赞数 1

分类专栏： asp.net C# 文章标签： button asp server object delete

本文链接：https://blog.youkuaiyun.com/deltazxm/article/details/1469583

版权

asp.net 同时被 2 个专栏收录

8 篇文章

订阅专栏

2 篇文章

订阅专栏

这样做的目的可以同时删除多个行的数据.而不必要一个一个的点...

在前面GridView控件中添加几个控件

<asp:TemplateField HeaderText="选择">
                <ItemTemplate>
                    <asp:CheckBox ID="CheckBox2" runat="server" />
                </ItemTemplate>
            </asp:TemplateField>

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="全部选中" />
<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="删除所选" />

后台操作代码:

protected void Button1_Click(object sender, EventArgs e)
    {
        if (Button1.Text == "全部选中")
        {
            foreach (GridViewRow row in GridView1.Rows)
            {
                CheckBox CheckBox2 = (CheckBox)row.Cells[0].FindControl("CheckBox2");
                CheckBox2.Checked = true;
            }
            Button1.Text = "全部不选";
        }
        else
        {
            foreach (GridViewRow row in GridView1.Rows)
            {
                CheckBox CheckBox2 = (CheckBox)row.Cells[0].FindControl("CheckBox2");
                CheckBox2.Checked = false;
            }
            Button1.Text = "全部选中";
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        foreach (GridViewRow row in GridView1.Rows)
        {
            CheckBox CheckBox2 = (CheckBox)row.Cells[0].FindControl("CheckBox2");
            if (CheckBox2.Checked == true)
            {
                SqlConnection conn = Fun.InitConn();
                SqlCommand comm = new SqlCommand();
                comm.Connection = conn;
                comm.CommandText = "delete from Comment where Comment_ID='" + row.Cells[2].Text + "' ";
                conn.Open();
                comm.ExecuteNonQuery();
                conn.Close();
            }
        }
    }

这样就以实现删除选中的行了