GridView Paging Sample in ASP.NET

Here, I will explain how to show a GridView with various types of paging in ASP.NET. We use C# code to bind the SQL data with a GridView control. The following simple steps will be used to make your ASP.NET GridView control with paging enabled. The GridView control provides you with an easy way to display the number of items on a page without taking up much space with the help of paging. First, we create an SQL Server database table.

Creating a table in SQL Server database

Now, create a table named Userinfo with columns UserID, UserName, and Country. Set the identity property=true for UserID. The table looks as follows.

Now, insert data into the table.

First of all, drag the GridView control from the Data Controls menu. It will add the GridView control's HTML source code as given above.

<asp:GridView ID="GridView2" runat="server">  
</asp:GridView>

Now add the following namespace.

using System.Data.SqlClient;  
using System.Data;

Now, write the connection string to connect to the database.

string strConnection = "Data Source=.; uid=sa; pwd=wintellect; database=Rohatash;";

Now, double-click on the page and write the following code for binding the data with the GridView.

protected void Page_Load(object sender, EventArgs e) {  
    BindData();  
}  
protected void BindData() {  
    string strConnection = "Data Source=.; uid=sa; pwd=wintellect;database=Rohatash;";  
    SqlConnection con = new SqlConnection(strConnection);  
    con.Open();  
    SqlCommand cmd = new SqlCommand("select * from Userinfo", con);  
    DataSet ds = new DataSet();  
    SqlDataAdapter da = new SqlDataAdapter(cmd);  
    da.Fill(ds);  
    GridView1.DataSource = ds;  
    GridView1.DataBind();  
    con.Close();  
}

Implement PageIndexChanged

Once the event PageIndexChanging is executed, the event will be fired for PageIndexChanged paging. In this event, you can safely bind the grid again to access the second page. It is always preferable to cache the data used to bind the data source.

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) {  
    GridView1.PageIndex = e.NewPageIndex;  
    BindData();  
}

There are four types of paging mode styles available in GridView. The following are the names of the types of paging mode styles.

1. NumericFirstLast
2. Numeric
3. NextPrevious
4. NextPreviousFirstLast

Now click on the GridView control to load the control properties at the right-side panel; press F4 and set the following properties of the GridView.