Click here to Skip to main content
13,256,123 members (24,188 online)
Click here to Skip to main content
Add your own
alternative version


25 bookmarked
Posted 13 Sep 2006

Custom Paging for DataList

, 13 Sep 2006
Rate this:
Please Sign up or sign in to vote.
Custom Paging for DataList


In this article i will explain a method for providing custom paging for datalist or repeater.

As you know the datalist is a very powerful control with one drawback that it does not have built-in paging capability, a feature the DataGrid offers. to provide paging to datalist or repeater we can either use "PagedDataSource" class, found in the System.Web.UI.WebControls namespace for auto paging like the datagrid or implement custom paging functionality.

So here is the scenario, i have an image gallery with 8 images per page. i need to provide paging so the user can navigate and view all images. The first step is to create the datalist and paging links.


<asp:DataList runat="server" id="dlGallery" 

    RepeatColumns="4" RepeatDirection="Horizontal">
<table border="0" cellpadding="0" cellspacing="0">
<img src="<%#DataBinder.Eval(Container.DataItem,"Image_URL")%>" width="90" 

//Next/Prev Links. 
<table border="0" width="410">
<td align="left"><asp:LinkButton ID="lbtnPrev" 

<td align="right"><asp:LinkButton ID="lbtnNext" 


//The Code Behind

Create a public function that will return only the neccessary rows (After paging). For that we need five static variables.

private int imgID;
private string imgTitle;
private string imgURL;
private static int pageSize = 8; 
//(This one will hold the no of records return 
//i mean "no. of records per page").
private static int pageIndex = 0; 
//(This one is for checking the current page). 
public DataSet GetAllImagesCustom(int pageIndex, out int outPageIndex)

int count = 0;
DataSet ds = new DataSet();
ds = //retrieve the data from the database.

//for paging
int page = 0;

//checking the whether the pageIndex value is not <First and >Last.
//And if it is then assigning the default 
//values for pageIndex and page variables. 
if(((pageIndex-1) <= (ds.Tables[0].Rows.Count/pageSize)) && 
(pageIndex-1) >= 0)
//If the pageIndex is >=first and =<last then assigning the start position
//eg. if pageIndex = 2 then value of 'page' = 8. 
//So in the loop it will add rows to the table
//from the 8 th row.

page = pageSize * (pageIndex-1);
//Assigning default values. 
page = 0;
pageIndex = 1;

//creating a data table for adding the required rows or u 
//can clone the existing table.

DataTable dtImg = new DataTable("Images");
DataColumn newCol = new DataColumn("Image_ID",Type.GetType("System.Int32"));
dtImg.Columns.Add(newCol);//For storing image id. 
newCol = new DataColumn("Image_Title",Type.GetType("System.String"));
dtImg.Columns.Add(newCol);//For storing image Title. 
newCol = new DataColumn("Image_URL",Type.GetType("System.String"));
dtImg.Columns.Add(newCol);//For storing image URL. 
//adding the required rows to the datatable dtImg. 
foreach(DataRow nRow in ds.Tables[0].Rows)
//if the page=8 and pageIndex =2 then
//rows between 8 to 16(if exists) will be added to the new table. 
if(count >= page && count < (pageSize * pageIndex))
//Adding rows to the datatable 'dtImg'. 
outPageIndex = pageIndex;
return ds;
catch(Exception ex)
throw ex;
public void BindList()
DataSet ds = new DataSet();
ds = GetAllImagesCustom(Convert.ToInt32(txtPageIndex.Text), 
out outPageIndex);
dlGallery.DataSource = ds;
//Assigning the new pageIndex value returned from the 
//function to the Hidden textbox.
txtPageIndex.Text = Convert.ToString(outPageIndex);

Now we have a datalist with 8 images per page. But still we hav'nt done the navigation part. Thats simple as u can see from the above function there isn't much logic needed. we only need to plus or minus the pageindex value and call the BindList function.

private void lbtnPrev_Click(object sender, System.EventArgs e)
//Actual pageIndex -1 
txtPageIndex.Text = Convert.ToString(Convert.ToInt32(txtPageIndex.Text) - 1);
private void lbtnNext_Click(object sender, System.EventArgs e)
//Actual pageIndex +1 
txtPageIndex.Text = Convert.ToString(Convert.ToInt32(txtPageIndex.Text) + 1);

Thats all Finished !!!.


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


About the Author

Sreejith Thathanattu
Software Developer
India India
No Biography provided

You may also be interested in...

Comments and Discussions

General[My vote of 1] Incomplete code Pin
dineshkumarw18-Dec-14 21:32
memberdineshkumarw18-Dec-14 21:32 
GeneralMy vote of 1 Pin
computeria27-Oct-10 2:28
membercomputeria27-Oct-10 2:28 
GeneralMy vote of 1 Pin
vasuhajare12-Aug-10 1:40
membervasuhajare12-Aug-10 1:40 
GeneralMy vote of 1 Pin
Tejaswini Prashant J20-Jun-10 22:16
memberTejaswini Prashant J20-Jun-10 22:16 
GeneralThanks!!! Pin
yeya8a27-Nov-09 12:23
memberyeya8a27-Nov-09 12:23 
GeneralMy vote of 1 Pin
bhairavtailor21-Nov-09 5:18
memberbhairavtailor21-Nov-09 5:18 
GeneralThis is also helpfulCustom Paging for DataList Pin
rajendra malav2-Sep-09 2:41
memberrajendra malav2-Sep-09 2:41 
GeneralI can't see the source code Pin
dothechuan19-May-08 11:35
memberdothechuan19-May-08 11:35 
GeneralRetun wrong table Pin
HasithaKavirathna12-Feb-07 19:44
memberHasithaKavirathna12-Feb-07 19:44 
GeneralFormat your article properly Pin
cykophysh397-Feb-07 5:52
membercykophysh397-Feb-07 5:52 
QuestionWhere does the txtPageIndex come into play? Pin
theRexMundi18-Oct-06 7:04
membertheRexMundi18-Oct-06 7:04 
GeneralYour Codes Have two Mistakes Pin
Mahdi Yousefi26-Sep-06 2:54
memberMahdi Yousefi26-Sep-06 2:54 

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

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

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.171114.1 | Last Updated 13 Sep 2006
Article Copyright 2006 by Sreejith Thathanattu
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid