How to Implement Paging in GridView Control in ASP.Net

Introduction

GridView is one of the most common tools for displaying data in a grid format in ASP.NET. When the data becomes large, paging helps the users to view chunks of data and also increases page load time. In this article, we will see how to implement paging in a GridView control.

So, let's dig directly into the code.

ASPX Page

• In your Visual Studio solution, on any page drag and drop a GridView control. Let's name it grdData.
  
• Set the AllowPaging property of the GridView to true.
  
• Handle the OnPageIndexChanging event of the GridView.
  
• By default GridView displays 10 records per page. If you want to modify the number of records displayed per page, set the PageSize property of the GridView to your desired number. In this example, I have set this property to 5.
  
• The following is the complete GridView code in the aspx page.

<asp:gridview ID="grdData" runat="server" AutoGenerateColumns="False" CellPadding="4" PageSize="5"
        ForeColor="#333333" GridLines="None" Width="200" AllowPaging="True"
        OnPageIndexChanging="grdData_PageIndexChanging">
        <alternatingrowstyle BackColor="White" ForeColor="#284775"></alternatingrowstyle>
          <columns>
             <asp:boundfield DataField="ID" HeaderText="ID"></asp:boundfield>
             <asp:boundfield DataField="Name" HeaderText="Name"></asp:boundfield>
          </columns>
           <editrowstyle BackColor="#999999"></editrowstyle>
           <footerstyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White"></footerstyle>
           <headerstyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White"></headerstyle>
           <pagerstyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center"></pagerstyle>
           <rowstyle BackColor="#F7F6F3" ForeColor="#333333"></rowstyle>
           <selectedrowstyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333"></selectedrowstyle>
           <sortedascendingcellstyle BackColor="#E9E7E2"></sortedascendingcellstyle>
           <sortedascendingheaderstyle BackColor="#506C8C"></sortedascendingheaderstyle>
           <sorteddescendingcellstyle BackColor="#FFFDF8"></sorteddescendingcellstyle>
           <sorteddescendingheaderstyle BackColor="#6F8DAE"></sorteddescendingheaderstyle>
</asp:gridview>

ASPX.CS Page

• Create a new function that loads data from your data repository (database) and bind it to the GridView. Let's name it LoadGridData().
  
• On the Page_Load event, call the LoadGridData() after checking the IsPostback property of the page.
  
• In the grdData_PageIndexChanging event, write the following code. In the following code, we are setting the NewPageIndex property of the GridView and calling the LoadGridData() fucntion again. The .Net GridView automatically handles the internal stuff for displaying only the data for the selected page.
  
• The following is the complete code from the .aspx.cs page: 

protected void Page_Load(object sender, EventArgs e)
{
   if (!IsPostBack)
   LoadGridData();
}
private void LoadGridData()
{
     //I am adding dummy data here. You should bring data from your repository.
     DataTable dt = new DataTable();
     dt.Columns.Add("Id");
     dt.Columns.Add("Name");
     for (int i = 0; i < 10; i++)
     {
           DataRow dr = dt.NewRow();
           dr["Id"] = i + 1;
           dr["Name"] = "Student " + (i + 1);
           dt.Rows.Add(dr);
     }
     grdData.DataSource = dt;
     grdData.DataBind();
}
protected void grdData_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
     grdData.PageIndex = e.NewPageIndex;
     LoadGridData();
}

You're done.

 

I hope you like this! Keep learning and sharing! Cheers!