Click here to Skip to main content
11,642,855 members (75,070 online)
Click here to Skip to main content

Paging using PagedDataSource class

, 18 Sep 2006 98.4K 141 46
Rate this:
Please Sign up or sign in to vote.
Paging using PagedDataSource class for Repeater or Datalist

Introduction

When we want to display data in Datalist or repeater we often have one problem PAGING. Datalist and Repeater both are powerful controls to customize "How the data is displayed in page".

DataList and Repeater both doesn't have auto paging support like the datagrid. Usually we diffent kind of custom paging to overcome this issue.

But there is a class in the .NET Framework that we can use to provide datagrid like paging support to datalist and repeater.

Here i will explain how to use the "PagedDataSource class" (System.Web.UI.WebControls).

In this example i will use a datalist to create an image gallery with paging support.

So lets create the datalist,

<asp:DataList runat="server" 
id="dlGallery" RepeatColumns="4" 
RepeatDirection="Horizontal">
<ItemTemplate>
<table border="0" 
cellpadding="0" 
cellspacing="0">
  <tr>
       <td><img  src="<%#DataBinder.Eval(Container.DataItem,"Image_URL")%>"  
width="90" 
height="90">
   </td>
  </tr>
         
</table>
</ItemTemplate>
</asp:DataList>

For the paging create two linkbuttons,

<table border="0" width="410">
<tr>
<td 
align="left"><asp:LinkButton 
ID="lbtnPrev" Runat="server">Prev</asp:LinkButton> 
</td>

<td align="right"><asp:LinkButton ID="lbtnNext" 
Runat="server">Next</asp:LinkButton> 
</td>
</tr>
</table>

         


Now the html part is over now we have to bind the data to the datalist.
For that lets create a public function "BindList()".

public void BindList()

{
<P>//Creating an object for the 'PagedDataSource' for holding the data.  </P>
<P>PagedDataSource objPage = new PagedDataSource();</P>

Now the datalist will display the first 8 records ( because i set "objPage.PageSize = 8").

For navigation we have to add littile bit code to the event handlers.  

private void lbtnPrev_Click(object sender, System.EventArgs e)

{
 CurrentPage -=1;
 BindList();
}

private void lbtnNext_Click(object sender, System.EventArgs e)

{
 CurrentPage +=1;
 BindList();
}

See we only need to +/- the value of the "CurrentPage " to provide navigation.

If u want enable/disable the navigation links according to the first/last page then add this few lines after the " dlGallery.DataBind();" line.

<P>//Checking for enabling/disabling next/prev buttons.
//Next/prev buton will be disabled when is the last/first page of the pageobject.
   
lbtnNext.Enabled = !objPage.IsLastPage;
lbtnPrev.Enabled = !objPage.IsFirstPage;
<P>   </P>

Thats all. So here is the complete BindList function.

public void BindList()

{
<P>//Creating an object for the 'PagedDataSource' for holding the data. 
 
PagedDataSource objPage = new PagedDataSource();
   
<P>try
{
 
 DataSet ds = ....\\DataSource.
    
 objPage.AllowPaging = true;
     
 //Assigning the datasource to the 'objPage' object.
 objPage.DataSource = ds.Tables["Gallery"].DefaultView;
<P> //Setting the Pagesize
 objPage.PageSize = 8;
     
 //"CurrentPage" is public static variable to hold the current page index value declared in the global section. </P><P> objPage.CurrentPageIndex = CurrentPage;</P>
<P> //Checking for enabling/disabling next/prev buttons.
 //Next/prev buton will be disabled when is the last/first page of the pageobject.
   
 lbtnNext.Enabled = !objPage.IsLastPage;
 lbtnPrev.Enabled = !objPage.IsFirstPage;
   
 //Assigning Datasource to the DataList.
 dlGallery.DataSource = objPage;
 dlGallery.DataKeyField = "Image_ID";
 dlGallery.DataBind();
<P>}
    
catch(Exception ex)
{
 throw ex;
}
<P>}</P>

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Sreejith Thathanattu
Software Developer
India India
No Biography provided

You may also be interested in...

Comments and Discussions

 
QuestionCorrections Pin
dineshkumarw18-Dec-14 23:52
memberdineshkumarw18-Dec-14 23:52 
QuestionGood Job ! Pin
johann678801-Nov-13 5:44
memberjohann678801-Nov-13 5:44 
GeneralGood article Pin
Rohit_kakria3-Feb-11 1:07
memberRohit_kakria3-Feb-11 1:07 
GeneralMy vote of 1 Pin
Devinmccloud27-Nov-10 21:14
memberDevinmccloud27-Nov-10 21:14 
GeneralMy vote of 2 Pin
nishant.maurya2-Nov-10 20:09
membernishant.maurya2-Nov-10 20:09 
QuestionHow to use custom paging with paged datasource Pin
winheart16-Dec-09 22:27
memberwinheart16-Dec-09 22:27 
GeneralCurrentPage" is public static variable to hold the current page index value declared in the global section Pin
asmani20093-Nov-09 0:58
memberasmani20093-Nov-09 0:58 
GeneralMy vote of 1 Pin
Arinte18-May-09 2:57
memberArinte18-May-09 2:57 
Generaldont understand DataSet ds = ....\\DataSource Pin
snikos11128-Jan-09 23:36
membersnikos11128-Jan-09 23:36 
Generaldatalist not populating Pin
Rajafusionware6-Jan-09 22:16
memberRajafusionware6-Jan-09 22:16 
GeneralGood one Pin
Haresh Ambaliya24-Dec-08 0:57
memberHaresh Ambaliya24-Dec-08 0:57 
GeneralGood Article - sorry its from 4guysFromRolla ... Pin
junkpraveen8-May-08 22:47
memberjunkpraveen8-May-08 22:47 
GeneralRe: Good Article - sorry its from 4guysFromRolla ... Pin
Arinte18-May-09 2:56
memberArinte18-May-09 2:56 
GeneralProblem with database connection with my database ! Need Help Pin
Tyrone Boon21-Mar-08 7:54
memberTyrone Boon21-Mar-08 7:54 
GeneralDoesnt Bind PagedDataSource Object Pin
vijendraAver12312-Mar-08 1:46
membervijendraAver12312-Mar-08 1:46 
GeneralRe: Doesnt Bind PagedDataSource Object Pin
Sreejith Thathanattu12-Mar-08 23:29
memberSreejith Thathanattu12-Mar-08 23:29 
Questionnice works but what about ?? Pin
Amr Al-khatib28-Oct-07 2:32
memberAmr Al-khatib28-Oct-07 2:32 
AnswerRe: nice works but what about ?? Pin
williaml30-Mar-08 12:36
memberwilliaml30-Mar-08 12:36 
GeneralVery Very Nice ! Pin
haitham hamed housin12-Sep-07 5:41
memberhaitham hamed housin12-Sep-07 5:41 
GeneralGreat Tip! Pin
codelacky9921-Jun-07 10:10
membercodelacky9921-Jun-07 10:10 
GeneralArticle that the geeks in Microsoft should read! Pin
taminha19-Mar-07 1:42
membertaminha19-Mar-07 1:42 
GeneralFantastic article Pin
netbeaz20-Feb-07 12:43
membernetbeaz20-Feb-07 12:43 
Questiondatalist paging Pin
vipul.excel14-Nov-06 5:22
membervipul.excel14-Nov-06 5:22 
GeneralVery good article! Pin
jonas_berg5-Oct-06 4:30
memberjonas_berg5-Oct-06 4:30 
GeneralRe: Very good article! Pin
Sreejith Thathanattu22-Oct-06 23:47
memberSreejith Thathanattu22-Oct-06 23:47 
GeneralRe: Very good article! Pin
Chris Cameron29-Nov-06 8:54
memberChris Cameron29-Nov-06 8:54 
GeneralNice article Pin
vik2026-Sep-06 19:51
membervik2026-Sep-06 19:51 
GeneralRe: Nice article Pin
Sreejith Thathanattu22-Oct-06 23:48
memberSreejith Thathanattu22-Oct-06 23:48 

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
Web03 | 2.8.150731.1 | Last Updated 19 Sep 2006
Article Copyright 2006 by Sreejith Thathanattu
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid