Display a recordset splited in pages without data reload

[ejanakieff]

I have a result page that display the results (are into a ADO recordset) splited in pages. In every page I show 10 results.

The problem is every time I access a different page, I reload the asp page who remake the query to the database.

It is possible to do the query database only one time, save the results into a recordset, and display the results of this recordset splited in pages of 10 results?

Thanks,
Eva Janakieff

 

[gc1234]

use

myArrary = recordSet.GetRows()

that way you dont need secondary connections, executions etc

 

[ejanakieff]

OK, and then when I change the page:
I have to pass this array by post parameter?

Or how?

Thanks.

 

[simonchristieis]

You will have to store the data on the server somehow, so why not just requery the database each time the page is loaded.

Adding a parameter ?startAt=10 would let you know what records to show.