devxlogo

ASP Scrolling Through a Resultset

ASP Scrolling Through a Resultset

Question:
How can I display groups of records (for example, the first 10 records), then allow the user to click Next to display the next set of records? I have tried leaving the resultset/connection open, but I can’t seem to reattach to it.

Answer:
You cannot reuse the recordset efficiently. Your best way out is to program your SQL retrieval code so that it only brings back the records you need, by passing some sort of a begin or end marker. So the first time you ask for Record 1 plus the next nine records. The next time, you ask for a set of records beginning at Record 10 and so on.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist