Paging In Gridview:
Page Indexing
or pagination is useful in case of large data display. In this article I will
explain how to implement pagination in gridview control in ASP.NET.
Create table in database:
Create Table “Student_Info”
in Database “Blog” and Enter some data
to display.
Column Name
|
DataType
|
Student_Id
|
Int
|
Student_name
|
Varchar(100)
|
Age
|
Int
|
Class
|
Varchar(100)
|
Design Asp.NET web Form:
Now Add
Gridview Control on webpage and set “AllowPaging” Property “True”. Now handle “OnPageIndexChanging”
event of Gridview.
<asp:GridView ID="GridView1" runat="server" AllowPaging="true" AutoGenerateColumns="False" ForeColor="#333333" PageSize="7" OnPageIndexChanging="GridView1_PageIndexChanging">
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<Columns>
<asp:BoundField DataField="Student_name" HeaderText="Name" />
<asp:BoundField DataField="Age" HeaderText="Age" />
<asp:BoundField DataField="Class" HeaderText="Class" />
</Columns>
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
</asp:GridView>
|
Asp.NET Code:
Import Name Spaces:
C#: Add Following Namespaces.
Using System.Data;
Using System.Data.SqlClient;
Using System.Configuration;
|
VB.NET: Import Following Namespaces.
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
|
Bind gridview And Implement Paging :
Bind grid with
database table on Page_Load Event of the page and Implement paging on PageIndexChanging Event of gridview.
C#
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Fill_grid();
}
}
public void Fill_grid()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlDataAdapter adpData = new SqlDataAdapter("select *
from Student_info", con);
DataTable dt = new DataTable();
adpData.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
con.Close();
}
|
protected void
GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
Fill_grid();
}
|
VB.NET
'create connection
using web config
Private con As New
SqlConnection(ConfigurationManager.ConnectionStrings("con").ConnectionString)
'Page load event
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
If Not IsPostBack Then
Fill_grid()
End If
End Sub
Public Sub Fill_grid()
If con.State = ConnectionState.Closed Then
con.Open()
End If
Dim adpData As New SqlDataAdapter("select *
from Student_info", con)
Dim dt As New DataTable()
adpData.Fill(dt)
GridView1.DataSource = dt
GridView1.DataBind()
con.Close()
End Sub
'implementation of Gridview Pagination
Protected Sub
GridView1_PageIndexChanging(sender As Object, e As
GridViewPageEventArgs) Handles GridView1.PageIndexChanging
GridView1.PageIndex = e.NewPageIndex
Fill_grid()
End Sub
|
Demo: