How to create paging in Gridview Using C#

November 23 2019 by Admin

In this article, we will explore how to create paging in Gridview using C# with an example and sample code.

In this article, we will explore how to create paging in Gridview using C# with an example and sample code. In this example, we have used ASP Gridview control and set the properties AllowPaging="true" and PageSize="5" and event OnPageIndexChanging="gvcustomers_PageIndexChanging" in the gridview.

Required namespaces

We will need to use the following namespaces.

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

HTML

In the html we have taken ASP Gridview Control.

<html>

<title>How To Create Paging in Gridview Using C#</title>

</head>

<body>

<div>

<asp:GridView ID="gvcustomers" AutoGenerateColumns="false" CssClass="table table-bordered" AllowPaging="true" PageSize="5" runat="server" OnPageIndexChanging="gvcustomers_PageIndexChanging">

<asp:TemplateField HeaderText="Name">

<asp:Label Text='<%#Eval("Username")%>' runat="server" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Role">

<asp:Label Text='<%#Eval("role")%>' runat="server" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Created Date">

<asp:Label Text='<%#Eval("CreatedDate")%>' runat="server" />

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</div>

</form>

</body>

</html>

we have get data in the pageload Method and using inbuild gridview event gvcustomers_PageIndexChanging

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

this.Getusers();

}

public void Getusers()

{

try

{

string connnection = Convert.ToString(ConfigurationManager.ConnectionStrings["Connection"]);

SqlConnection con = new SqlConnection(connnection);

SqlCommand cmd = new SqlCommand("Select * from Users", con);

SqlDataAdapter sda = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

sda.Fill(dt);

if (dt.Rows.Count > 0)

{

gvcustomers.DataSource = dt;

gvcustomers.DataBind();

}

catch (Exception ex)

{

throw ex;

}

protected void gvcustomers_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

gvcustomers.PageIndex = e.NewPageIndex;

this.Getusers();

}

Screenshot

How To Create Paging in Gridview Using C#

Download

Home > ASP.NET > How to create paging in Gridview Using C#

How to create paging in Gridview Using C#

Related Articles

How to use gridview in asp.net with C# using Mysql

01-02-2019 23:51:00 By Admin

2451 Views

How to use gridview with datatable in asp.net with C# using Mysql

03-02-2019 21:50:00 By Admin

2091 Views

How to bind gridview with datatable in asp.net with C# without using the database

03-02-2019 22:35:00 By Admin

5783 Views

How to bind gridview with datatable in asp.net with c# without using the database

03-02-2019 22:35:00 By Admin

2660 Views

How to fetch data from database in Asp.net

10-02-2019 22:05:00 By Admin

7799 Views

How to insert and retrieve data from the database in vue js using asp.net with C#

04-03-2019 07:54:00 By Admin

8571 Views

How to bind Repeater control from database in Asp.net

10-03-2019 10:51:00 By Admin

4254 Views

how to save and retrieve session value in asp.net

30-03-2019 05:59:00 By Admin

2166 Views

How to use Session variables asp.net c#

02-04-2019 11:24:00 By Admin

12238 Views

How to pass list of items using session in asp.net

02-04-2019 12:07:00 By Admin

3442 Views

Comments

Leave a Reply

Comment:^*

Please your Comment !

Email ID:^*

Enter Your Email Id ! Enter Your Validate Email Id !

Name:^*

Enter your Name !

RECENT POSTS

Technology

Information

Tags

Email Alerts

Home > ASP.NET > How to create paging in Gridview Using C#

Related Articles

How to use gridview in asp.net with C# using Mysql 01-02-2019 23:51:00 By Admin 2451 Views

How to use gridview with datatable in asp.net with C# using Mysql 03-02-2019 21:50:00 By Admin 2091 Views

How to bind gridview with datatable in asp.net with C# without using the database 03-02-2019 22:35:00 By Admin 5783 Views

How to bind gridview with datatable in asp.net with c# without using the database 03-02-2019 22:35:00 By Admin 2660 Views

How to fetch data from database in Asp.net 10-02-2019 22:05:00 By Admin 7799 Views

How to insert and retrieve data from the database in vue js using asp.net with C# 04-03-2019 07:54:00 By Admin 8571 Views

How to bind Repeater control from database in Asp.net 10-03-2019 10:51:00 By Admin 4254 Views

how to save and retrieve session value in asp.net 30-03-2019 05:59:00 By Admin 2166 Views

How to use Session variables asp.net c# 02-04-2019 11:24:00 By Admin 12238 Views

How to pass list of items using session in asp.net 02-04-2019 12:07:00 By Admin 3442 Views

Comments

Leave a Reply Comment:* Please your Comment ! Email ID:* Enter Your Email Id ! Enter Your Validate Email Id ! Name:* Enter your Name !

RECENT POSTS

Technology

Information

Tags

Email Alerts

How to use gridview in asp.net with C# using Mysql

01-02-2019 23:51:00 By Admin

2451 Views

How to use gridview with datatable in asp.net with C# using Mysql

03-02-2019 21:50:00 By Admin

2091 Views

How to bind gridview with datatable in asp.net with C# without using the database

03-02-2019 22:35:00 By Admin

5783 Views

How to bind gridview with datatable in asp.net with c# without using the database

03-02-2019 22:35:00 By Admin

2660 Views

How to fetch data from database in Asp.net

10-02-2019 22:05:00 By Admin

7799 Views

How to insert and retrieve data from the database in vue js using asp.net with C#

04-03-2019 07:54:00 By Admin

8571 Views

How to bind Repeater control from database in Asp.net

10-03-2019 10:51:00 By Admin

4254 Views

how to save and retrieve session value in asp.net

30-03-2019 05:59:00 By Admin

2166 Views

How to use Session variables asp.net c#

02-04-2019 11:24:00 By Admin

12238 Views

How to pass list of items using session in asp.net

02-04-2019 12:07:00 By Admin

3442 Views

Leave a Reply

Comment:^*

Please your Comment !

Email ID:^*

Enter Your Email Id ! Enter Your Validate Email Id !

Name:^*

Enter your Name !