Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 10, 2009 06:06 AM by LastPhoenix
Mar 30, 2005 09:19 AM|LINK
All of us would have implemented Paging in our applications.
Paging is particularly useful if you have lots of records to be displayed on a page and you can't get them displayed in one stretch. Say we have 1000 records to be displayed in a page. In this scenario, we cannot show up all the records in a single stretch
in the page. Hence we need to implement Paging functionality whereby users can see a set of records and then click on a Button/Link to view the next set of records.
This <a href="http://aspnet_harish.blogspot.com/2005_03_01_aspnet_harish_archive.html">Article</a> is useful to retrieve records in sets for displaying and useful in implementing custom paging.
Mar 31, 2005 07:42 AM|LINK
maybe it's not a correct link,I can't open it.[:'(]
Oct 29, 2009 07:05 AM|LINK
the link is not working.
Oct 29, 2009 07:26 AM|LINK
Oct 30, 2009 06:55 AM|LINK
You can take a look at the following page for information on how to page in ASP.NET:
Nov 10, 2009 06:06 AM|LINK
Thank you guys for your solution , But in sql 2005 we have ROW_NUMBER() Function that help you write storedprocedure much easier :
Look at this sp:
CREATE PROCEDURE sprocEmailAddressSelectList
(SELECT ROW_NUMBER() OVER (ORDER BY Id) AS Row,
FROM EmailAddress) AS EmailRows
(Row between (@startRowIndex) AND @startRowIndex + @pageSize - 1)
AND ContactPersonId = @contactPersonId
for more information you can look at this article :