Displaying information from a database table can be a science onto itself, especially as the sheer amount of information in a table grows. For example, imagine that you had a database table that contained 10,000 rows. If you wanted to display this information, simply listing all 10,000 rows on a single Web page would be unplausable - it would consume gobs of resources and would be far too much information to be useful for the visitor.
To overcome this problem, many developers "page" database table results. For example, instead of displaying all 10,000 rows, a developer might choose to display 20 rows per Web page. Each page would have Next and Previous links so the user could step through the data in digestible chunks.
Thankfully, ADO provides a method to accomplish this. There are three ADO properties - PageSize, AbsolutePage, and PageCount - that can be used to page results from any data store. A complete, working example of paging database results using these properties can be seen at: Paged Table Displays.
Another option for paging is to use stored procedures. The only drawback to this approach is that you must be using SQL Server as your data store. To learn more about this approach, be sure to read: Paging Through Records Using a Stored Procedure.
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.