Paging Through a Database Recordset
Written by Eric Smith, Northstar Computer Systems LLC
The ADO Recordset has an extra feature that makes it very easy to create paged output. Let's say that you have 1000 records in the resulting recordset and you want to show 75 per page. You first set the PageSize property to 75, and then the PageCount property will tell you how many pages, full and incomplete, you need to have. You can then set the AbsolutePage property to the page you want to go to in the recordset. This is quite fast and is much easier than doing it by hand.
Keywords: [
Uncategorized ASP Tips
]
Publication Date: 9/1/1999
|