How to select multible rows of gridivew using checkbox while using default paging. I am getting data only from first page of gridivew

Question

1.00/5 (1 vote)

See more:

i am trying to create a gridview how will hold big data i am using a checkbox to select he rows but i am getting rows only from first page of gridivew how to fix it.

What I have tried:

I have tried this.

<pre lang="ASP.NET"><pre><asp:GridView ID="datatable" Width="100%" runat="server" AutoGenerateColumns="False"
                                    CssClass="table table-striped jambo_table table-bordered grid-table sorted_table department-grid FixedHeader"
                                    OnRowCommand="datatable_RowCommand" OnRowDeleting="datatable_RowDeleting"
                                    OnRowDataBound="datatable_RowDataBound" OnPreRender="datatable_PreRender"
                                    ClientIDMode="Static" CellPadding="4" ForeColor="#333333"
                                    PageSize="50" GridLines="None" EmptyDataText="There is no product exists"
                                    ShowHeaderWhenEmpty="True">
                                    <Columns>
                                        <%--0--%>
                                        <asp:TemplateField ItemStyle-HorizontalAlign="Center" ItemStyle-VerticalAlign="Middle">
                                            <HeaderTemplate>
                                                <asp:CheckBox ID="chkheader" runat="server" Text="All" AutoPostBack="true" OnCheckedChanged="sellectAll" />
                                            </HeaderTemplate>
                                            <ItemTemplate>
                                                <asp:CheckBox runat="server" ID="chkSelect"></asp:CheckBox>
                                            </ItemTemplate>
                                        </asp:TemplateField>  </Columns>
                                </asp:GridView>

C#

<pre>  string PIDs = "";
            foreach (GridViewRow row in datatable.Rows)
            {
                CheckBox check = (CheckBox)row.FindControl("chkSelect");
                if (check.Checked)
                {
                    Label lbl_productid = (Label)row.FindControl("lbl_productid");
                    String PID = lbl_productid.Text.ToString();
                    if (PIDs.Length < 2)
                        PIDs = PID;
                    else
                        PIDs = PIDs + "," + PID;
                }

Posted 27-Jun-21 19:08pm

Member 15001218

Updated 27-Jun-21 22:19pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2021-06-27T22:19:00

When you switch to a different page, all of the controls for the current page are destroyed. The GridView does not maintain any state for pages which are not displayed.

You will need to handle the PageIndexChanging event[^], extract the selected rows from the current page, and store them somewhere. Then, when you want to get all selected rows, retrieve the stored selection from the other pages and combine it with the selected rows on the current page.

For example:

C#

private Dictionary<int, List<string>> PageSelections
{
    get
    {
        var value = (Dictionary<int, List<string>>)Session["SelectedPIDs"];
        if (value == null)
        {
            value = new Dictionary<int, List<string>>();
            Session["SelectedPIDs"] = value;
        }
        
        return value;
    }
}

private List<string> ExtractSelectedRows()
{
    var result = new List<string>();
    foreach (GridViewRow row in datatable.Rows)
    {
        if (row.RowType != DataControlRowType.DataRow) continue;
        
        CheckBox check = (CheckBox)row.FindControl("chkSelect");
        if (!check.IsSelected) continue;
        
        Label lbl_productid = (Label)row.FindControl("lbl_productid");
        result.Add(lbl_productid.Text);
    }
    
    return result;
}

protected void datatable_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
    // Save the selected rows before moving to the new page:
    PageSelections[datatable.PageIndex] = ExtractSelectedRows();
}

protected void datatable_DataBound(object sender, EventArgs e)
{
    // Restore the selected rows when a new page is displayed:
    List<string> selectedRows;
    if (!PageSelections.TryGetValue(datatable.PageIndex, out selectedRows)) return;
    if (selectedRows.Count == 0) return;
    
    foreach (GridViewRow row in datatable.Rows)
    {
        if (row.RowType != DataControlRowType.DataRow) continue;
        
        CheckBox check = (CheckBox)row.FindControl("chkSelect");
        Label lbl_productid = (Label)row.FindControl("lbl_productid");
        check.IsSelected = selectedRows.Contains(lbl_productid.Text);
    }
}

private IEnumerable<string> GetAllSelectedRows()
{
    // Save the selections from the current page:
    Dictionary<int, List<string>> pageSelections = PageSelections;
    pageSelections[datatable.PageIndex] = ExtractSelectedRows();
    
    // Return the PID from all selected rows:
    return pageSelections.SelectMany(pair => pair.Value);
}