Articles → ASP .NET GRIDVIEW → Gridview Paging In Asp.Net

Gridview Paging In Asp.Net

In this article, I will explain how to implement paging in gridview in asp.net. First of all create a table. From the table, we can fetch data and bind it with gridview. See the following figure for table structure.

Picture showing the database table with records

Click to Enlarge

The second step is to add a gridview and SQLDataSource control in a webform. See the following code.

<asp:GridView ID="gvTest" runat="server" DataSourceID="dsTest"></asp:GridView>
<asp:SqlDataSource ConnectionString="connection_string" ID="dsTest" SelectCommand="Select * from Member" runat="server" />

For implementing paging, we need to add 2 properties and one event

AllowPaging – Permissible values are true or false. For paging, we set the value to True.
PageSize – It means how many records will be visible on a single page.
OnPageIndexChanging – This is an event that is invoked when the user clicks on any page number in pager control.

So the code will be

<asp:GridView ID="gvTest" runat="server" DataSourceID="dsTest" AllowPaging="true" PageSize="2" OnPageIndexChanging="gvTest_PageIndexChanging"></asp:GridView>
<asp:SqlDataSource ConnectionString="connection_string" ID="dsTest" SelectCommand="Select * from Member" runat="server" />

And code behind is

protected void gvTest_PageIndexChanging(object sender, GridViewPageEventArgs e) {
	gvTest.PageIndex = e.NewPageIndex;
}

Output

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Thursday, May 21, 2015

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**