Blog

Paging in repeater using PagedDataSource class

Posted by Satyapriya Nayak in Blogs | ASP.NET Controls in C# on Sep 12, 2011

In this article we will know how to do Paging in repeater using PagedDataSource class.

Tweet
2840
0

Download Files: 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

Thanks for reading

This Feature is Sponsored By

DynamicPDF Merger is a developers dream for interacting with any existing PDF documents. Merge, append, split, form fill, flatten stamp and so much more.

comments

COMMENT USING

PREMIUM SPONSORS

DynamicPDF Developer Components

DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and add new content to existing PDF documents from within your applications.

More Blogs from this Blogger

Validate TextBox using JavaScript Display XML File Data into GridView using DataTable Search Record Display in GridView Display Data from Database to Label Delete multiple row by selecting checkbox on Data Gridview Update Male TO Female and Female To Male with single query Display username belong to selected item value from combo box Related records from one textbox to another Fetch multiple items to combobox from db Uncheck CheckBoxList items when button is clicked

View All

Options	Votes	%
Very Fast	4	7.69
OK	42	80.77
Slow	4	7.69
Very Slow	2	3.85
Total	52	100%


Speed of C# Corner

How do you find speed of C# Corner when visiting the site?

Very Fast OK Slow Very Slow

In Focus

Paging in repeater using PagedDataSource class