进一步熟悉gridview控件的功能

最新推荐文章于 2023-02-15 09:18:16 发布

double294

最新推荐文章于 2023-02-15 09:18:16 发布

阅读量975

点赞数

分类专栏： .net Web学习文章标签： asp button object javascript null server

本文链接：https://blog.youkuaiyun.com/double294/article/details/1496512

版权

.net Web学习专栏收录该内容

3 篇文章

订阅专栏

这篇博客介绍了如何在GridView控件中添加批量删除功能，包括在模板字段中加入复选框，实现客户端全选功能，并在服务器端处理批量删除操作。同时，还展示了如何在删除前进行用户确认，以及如何在页面重新绑定时回显已选择的项。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

前面已经知道了gridview的基本操作包括删除、编辑等，现在我想加入批量删除以及删除之前用户进行确认，添加数据等功能，这样的话就必须增加一列，加入模板域，在模板项内加入复选框，对gridview控件修改如下：

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
            AutoGenerateColumns="False" DataSourceID="AccessDataSource1" DataKeyNames="stu_xh">
            <Columns>
            <asp:TemplateField>
                    <ItemTemplate>
                        <asp:CheckBox ID="CheckBox1" runat="server" Checked="false" Text='<%#DataBinder.Eval(Container.DataItem,"stu_id") %>' />
                    </ItemTemplate>
                    <HeaderTemplate>
                         <input id="CheckAll" type="checkbox" οnclick="selectAll(this);" />本页全选
                    </HeaderTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="stu_xh" HeaderText="stu_xh" SortExpression="stu_xh" />
                <asp:BoundField DataField="stu_pwd" HeaderText="stu_pwd" SortExpression="stu_pwd" />
                <asp:BoundField DataField="stu_clsBDM" HeaderText="stu_clsBDM" SortExpression="stu_clsBDM" />
                <asp:BoundField DataField="stu_sfzh" HeaderText="stu_sfzh" SortExpression="stu_sfzh" />
                <asp:CommandField ShowDeleteButton="True" />
                <asp:BoundField DataField="stu_name" HeaderText="stu_name" SortExpression="stu_name" />
                <asp:CommandField ShowEditButton="True" />
            </Columns>
        </asp:GridView>

加入button删除确认： <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" OnClientClick="return confirm('确认要删除吗？');" />

加入javascript客户端实现复选框全选功能：

然后在gridview.aspx.cs里加入以下内容：

protected ArrayList SelectedItems
    {
        get
        {
            return (ViewState["mySelectedItems"] != null) ? (ArrayList)ViewState["mySelectedItems"] : null;
        }
        set
        {
            ViewState["mySelectedItems"] = value;
        }
    }
    protected void GridView1_DataBinding(object sender, EventArgs e)
    {

        //在每一次重新绑定之前，需要调用CollectSelected方法从当前页收集选中项的情况
        CollectSelected();
    }

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        //这里的处理是为了回显之前选中的情况
        if (e.Row.RowIndex > -1 && this.SelectedItems != null)
        {
            DataRowView row = e.Row.DataItem as DataRowView;
            CheckBox cb = e.Row.FindControl("CheckBox1") as CheckBox;
            if (this.SelectedItems.Contains(row["stu_id"].ToString()))
                cb.Checked = true;
            else
                cb.Checked = false;
        }
    }
    protected void CollectSelected()
    {
        ArrayList selectedItems = null;
        if (this.SelectedItems == null)
            selectedItems = new ArrayList();
        else
            selectedItems = this.SelectedItems;

        for (int i = 0; i < this.GridView1.Rows.Count; i++)
        {
            string id = this.GridView1.Rows[i].Cells[1].Text;
            CheckBox cb = this.GridView1.Rows[i].FindControl("CheckBox1") as CheckBox;
            if (selectedItems.Contains(id) && !cb.Checked)
                selectedItems.Remove(id);
            if (!selectedItems.Contains(id) && cb.Checked)
                selectedItems.Add(id);
        }
        this.SelectedItems = selectedItems;
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        CollectSelected();

        foreach (object tmp in this.SelectedItems)
        {
            string sqlstr;
            sqlstr= "delete from student where stu_xh='" + tmp.ToString()+"'";
            AccessDataSource1.DeleteCommand = sqlstr;
            //Response.Write(sqlstr);
           AccessDataSource1.Delete();

        }


            }