How to display the records in DataGrid by using the Paging

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=student;Integrated Security=True");

SqlDataAdapter da = new SqlDataAdapter("select*from student",con);

con.Open();

DataSet ds = new DataSet();

da.Fill(ds);

datagrid1.DataSource = ds;

datagrid1.DataBind();

con.Close();

}

protected void datagrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)

{

datagrid1.CurrentPageIndex = e.NewPageIndex;

}

}

Output: In this example the position of paging is apply at bottom. You can click on any no. of page you will see that page. Suppose that if you want to see the record of page number three then click on three. You will see the following output.

Figure 4: Output of the given example.

Custom Paging: In this section you will learn about Custom paging.

Example of Custom paging:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

<title>Custom Paging</title>

</head>

<body>

<form id="form1" runat="server">

<div>

<asp:DataGrid ID="datagrid1" runat="server" AllowCustomPaging="True" AllowPaging="True" OnPageIndexChanged="datagrid1_PageIndexChanged" BackColor="#C0C0FF" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" CellSpacing="2" ForeColor="Black" >

<PagerStyle Mode="NumericPages" BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />

<SelectedItemStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />

<ItemStyle BackColor="White" />

<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />

</asp:DataGrid>

</div>

</form>

</body>

</html>

Design view of the above code is as follows:

Figure 5: DataGrid with Custom paging property.

Default.aspx.cs:

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=student;Integrated Security=True");

SqlCommand cmd=new SqlCommand("select*from student",con);

con.Open();

datagrid1.DataSource = cmd.ExecuteReader();

datagrid1.DataBind();

con.Close();

}

protected void datagrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)

{

datagrid1.CurrentPageIndex = e.NewPageIndex;

}

}

Output:

Figure 6: Output of the Custom paging.

In the Custom paging you can not change the page. It is use to display the short amount of data.