Paging in repeater using PagedDataSource class

Satyapriya Nayak
13y
22.2k
0
2

Blog

Paging.rar

Drag and drop a Repeater control, one label, and two buttons controls to the WebPages.

Table structure

Table structure in sql

Program

Default.aspx code

<%@ 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>Untitled Page</title>
</head>
<body>
 <form id="form1" runat="server">
 <div>
 <table border="1">
 <asp:repeater id="repeater1" runat="server">
 <HeaderTemplate>
 Employee Details

 </HeaderTemplate>
 <itemtemplate>
 <tr>
 <td>ID</td>
 <td>NAME</td>
 <td>SALARY</td>
 <td>ADDRESS</td>
 <td>DESIGNATION</td>
 </tr>
 <tr>
 <td> <%#Eval("empid")%></td>
 <td> <%#Eval("empname")%></td>
 <td> <%#Eval("empsal")%></td>
 <td> <%#Eval("empadd")%></td>
 <td> <%#Eval("empdes")%></td>
 </tr>
 </itemtemplate>
 </asp:repeater>
 </table>
 <table width="100%" border="0">
 <tr>
 <td> <asp:label id="lbl1" runat="server" BackColor="Yellow" BorderColor="Yellow"
 Font-Bold="True" ForeColor="#FF3300"></asp:label></td>
 </tr>
 <tr>
 <td> <asp:button id="btnPrevious" runat="server" text="Previous" Width="60px"
 onclick="btnPrevious_Click"></asp:button>
 <asp:button id="btnNext" runat="server" text="Next" Width="60px"
 onclick="btnNext_Click"></asp:button></td>
 </tr>
 </table>
 </div>
 </form>
</body>
</html>

Default.aspx.cs code

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
 string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
 string str;
 SqlCommand com;
 SqlDataAdapter sqlda;
 DataSet ds;
 protected void Page_Load(object sender, EventArgs e)
 {
 if (!IsPostBack)
 {
 bindrepeater();
 }
 }
 private void bindrepeater()
 {
 SqlConnection con = new SqlConnection(strConnString);
 con.Open();
 str = "select * from employee";
 com = new SqlCommand(str, con);
 sqlda = new SqlDataAdapter(com);
 ds = new DataSet();
 sqlda.Fill(ds, "employee");
 PagedDataSource Pds1 = new PagedDataSource();
 Pds1.DataSource = ds.Tables[0].DefaultView;
 Pds1.AllowPaging = true;
 Pds1.PageSize = 3;
 Pds1.CurrentPageIndex = CurrentPage;
 lbl1.Text = "Showing Page: " + (CurrentPage + 1).ToString() + " of " + Pds1.PageCount.ToString();
 btnPrevious.Enabled = !Pds1.IsFirstPage;
 btnNext.Enabled = !Pds1.IsLastPage;
 repeater1.DataSource = Pds1;
 repeater1.DataBind();
 con.Close();
 }
 public int CurrentPage
 {
 get
 {
 object s1 = this.ViewState["CurrentPage"];
 if (s1 == null)
 {
 return 0;
 }
 else
 {
 return Convert.ToInt32(s1);
 }
 }

 set { this.ViewState["CurrentPage"] = value; }
 }
 protected void btnPrevious_Click(object sender, EventArgs e)
 {
 CurrentPage -= 1;
 bindrepeater();
 }
 protected void btnNext_Click(object sender, EventArgs e)
 {
 CurrentPage += 1;
 bindrepeater();
 }
}

Output

Paging in asp.net