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.

Share the Post:
data observability

Data Observability Explained

June 8, 2023

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

June 1, 2023

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

Show More