Click here to Skip to main content
Click here to Skip to main content

Allow Paging in Repeater and DataList Using C#

, 27 Aug 2009 CPOL
Rate this:
Please Sign up or sign in to vote.
A Web User Control to enable paging in Repeater and DataList controls.

Introduction

The Repeater and DataList are two very important controls and many developers use at least one of them in most of their websites or web applications. Also, these Controls are easy to use for UI developers, but their features are limited. The Gridview control has a very useful paging feature, but it's a complex control and you might not want to use it. And, if you want to use a Repeater or a DataList, they do not support paging, so what will you do ?!!

I will show you how to make a Repeater or a DataList that allows paging. I'll also make a web user control that anyone can use to allow paging in a Repeater or DataList control.

How to Decide to Use the DataGrid, DataList, or Repeater

The URL below describes the differences between a DataGrid, DataList, and a Repeater and helps to decide which one to use: http://msdn.microsoft.com/en-us/library/aa479015.aspx.

Advantages of the AllowPaging Control

It enables paging in Repeater and DataList controls. It is an easy to use Web User Control. The control depends on ObjectDataSource so, if you want to use SqlDataSource, just replace ObjectDataSource with SqlDataSource.

Using the code

The sample code is divided into three parts:

  1. The Default Page to add a Repeater or DataList control.
  2. The UCPager Web User Control that is responsible for paging.
  3. The GetData class to get data from the database.

Also, I'm using the Northwind database in this sample.

First, I'll talk about the User Control sample code. There are four important properties:

  • CurrentPage - sets or gets the current page number
  • Ods - pass to it the ObjectDataSource
  • ObjectControl - pass a Repeater or DataList
  • PageSize - pass an integer for how many records will appear in each page
/// <summary>
/// set or get the Current Page Number
/// </summary>
public int CurrentPage
{
    get
    {
        //get current page number
        object obj = this.ViewState["_CurrentPage"];
        if (obj == null)
        {
            return 0;
        }
        else
        {
            return (int)obj;
        }
    }
    set
    {
        //set in viewstate the current page number
        this.ViewState["_CurrentPage"] = value;
    }
}

/// <summary>
/// set or get ObjectDataSource that's use to bind the control
/// Like(Repeater or Datalist)
/// </summary>
public ObjectDataSource Ods { get; set; }

/// <summary>
/// set or get Control Name EX. (Repeater1 or Datalist1)
/// </summary>
public object ObjectControl { get; set; }

/// <summary>
/// set or get count of pages
/// page size determine how many records will appears in every page
/// </summary>
public int PageSize { get; set; }

The method below is responsible for binding a control and enabling or disabling the navigation buttons depending on how records are shown.

/// <summary>
/// bind controls with data
/// enable and disable controls depending on page number
/// check for object Control if it a Repeater or a DataList
/// </summary>
/// <returns>the count of pages</returns>
private int GetItems()
{
    //create new instance of PagedDataSource
    PagedDataSource objPds = new PagedDataSource();
    //set number of pages will appear
    objPds.PageSize = PageSize;
    objPds.DataSource = Ods.Select();
    objPds.AllowPaging = true;
    int count = objPds.PageCount;
    objPds.CurrentPageIndex = CurrentPage;
    if (objPds.Count > 0)
    {
        //dispaly controls if there are pages
        btnPrevious.Visible = true;
        btnNext.Visible = true;
        btnLastRecord.Visible = true;
        btnFirstRecord.Visible = true;
        lblCurrentPage.Visible = true;
        lblCurrentPage.Text = "Page " + 
          Convert.ToString(CurrentPage + 1) + " of " + 
          Convert.ToString(objPds.PageCount);
    }
    else
    {
        //disable controls if there are no pages
        btnPrevious.Visible = false;
        btnNext.Visible = false;
        btnLastRecord.Visible = false;
        btnFirstRecord.Visible = false;
        lblCurrentPage.Visible = false;
    }
    btnPrevious.Enabled = !objPds.IsFirstPage;
    btnNext.Enabled = !objPds.IsLastPage;
    btnLastRecord.Enabled = !objPds.IsLastPage;
    btnFirstRecord.Enabled = !objPds.IsFirstPage;
    //check for object control if it a DataList
    //we will use DList Variable
    if (ObjectControl is DataList)
    {
        DList = (DataList)ObjectControl;
        DList.DataSource = objPds;
        DList.DataBind();
    }
    //check for object control if it a Repeater
    //we will use Rep Variable
    else if (ObjectControl is Repeater)
    {
        Rep = (Repeater)ObjectControl;
        Rep.DataSource = objPds;
        Rep.DataBind();
    }
    return count;
}

In the First Record button:

//go to first Page
CurrentPage = 0;

GetItems();

In the Last Record button:

//go to last page
CurrentPage = GetItems() -1;

GetItems();

In the Previous Record button:

//back to previous page
CurrentPage -= 1;

GetItems();

In the Next Record button:

//go to next page
CurrentPage += 1;

GetItems();

In the Default Page, all you need is bind the AllowPaging control properties, and the code below explains that:

UCPager1.Ods = ObjEmployees;

UCPager1.ObjectControl = Repeater1;

UCPager1.PageSize = 1;

I'm waiting for your comments. You can read my blog here: http://waleedelkot.blogspot.com/.

Points of Interest

This control saves a lot of time for me, and I hope it helps you too.

History

  • 27-08-2009: First version released.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Waleed Elkot
Software Developer (Senior) Equinox Web
Egypt Egypt
I have 5 years experience working as a Software Developer. I have a wide range of experience in programming and I am skilled in the use of Visual Studio.NET 2008, Windows AppLication, Web Application, Web Services, Windows Services, WPF, HTML, Java Script, Ajax, ASP.NET, DevExpress Controls, Office Application Programmability in Visual Studio.NET 2008, creating web and windows applications using C#.NET and experienced in using all Microsoft Office Applications.

Comments and Discussions

 
AnswerPaging with Repeater control in ASP.NET PinmemberChandanBadgujar17-Jun-13 6:09 
QuestionThanks!!! Pinmemberpradippr11-May-13 4:12 
QuestionAbout DataSource Pinmembercsharpbd3-Feb-13 9:22 
GeneralMy vote of 5 Pinmembercsharpbd3-Feb-13 9:20 
QuestionHow to put paging in the top and the bottom of the repeater PinmemberTavob4-Jan-13 5:38 
GeneralMy vote of 4 Pinmembernipunasilva24-May-11 0:59 
GeneralThank you very much Pinmemberviet200613-May-11 6:01 
Generalit not working in gridview Pinmembersameer das23-Oct-10 2:28 
GeneralAsp.Net PinmemberPrerna Gakhar23-Sep-10 4:49 
QuestionAsp.net(C#) PinmemberPrerna Gakhar23-Sep-10 4:45 
GeneralAccess Database PinmemberUKMelody23-Mar-10 12:20 
GeneralHelp Please! PinmemberUKMelody22-Mar-10 15:05 
GeneralQuite Usefull Pinmemberozgurkaplan22-Feb-10 4:24 
GeneralMy problem is this I need to display 3 records across and 5 rows down Pinmembermikelopilato30-Sep-09 12:49 
GeneralThis is also helpful for paging with datalist Pinmemberrajendra malav2-Sep-09 2:34 
GeneralRe: This is also helpful for paging with datalist PinmemberWaleed Elkot2-Sep-09 3:51 
GeneralRe: This is also helpful for paging with datalist Pinmembernskwaits30-Sep-09 23:14 
GeneralCompile Code Pinmemberhulkonline31-Aug-09 0:31 
GeneralRe: Compile Code PinmemberWaleed Elkot31-Aug-09 0:41 
Generalcool PinmemberAhmed Elkot27-Aug-09 16:55 
GeneralRe: cool PinmemberWaleed Elkot27-Aug-09 16:57 
GeneralNice PinmemberWael Hussein27-Aug-09 16:46 
GeneralRe: Nice PinmemberWaleed Elkot27-Aug-09 16:58 
GeneralRe: Nice PinmemberMember 295735628-Aug-09 3:06 
GeneralRe: Nice PinmemberWaleed Elkot28-Aug-09 15:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.141223.1 | Last Updated 27 Aug 2009
Article Copyright 2009 by Waleed Elkot
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid