Recordset pagination

[diembi]

Hello,
i need obtain pages in a recordset for a very large query without get all records in the recordset. If I use OleDbDataAdapter.Fill(DataSet, startRecord, maxRecords, "tablename") the sqlserver gives me all records (1000000) and after this the pagination show me the records in X records. I would like the sqlserver gives me the records in pages with 1000 records(for example) and after show these 1000 records.

Thank you!!!

 

[jmeckley]

which database are you using? if the db provides a pagination operator use this (check the db's docs or db specific forum if you don't know).
if the db doesn't have pagination, then you will need to:
1. fetch all the records into the dataset/table.
filter the subset of records and pass that to the presentation.
2. create a set of temp tables/sub queries to filter out the correct records. and load the dataset/table as you normally would.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[diembi]

Hello,
the database is Microsoft® SQL Server™ 2000. Thank you.

 

[jshurst]

I would do this at the SQL Server level. You could write a query that returned the first 100 results, then after that returned the next 100. A Stored Proc with a parameter passed to it. SQL Server 2005 has a ROW_COUNT function which helps out with paging...2000 doesn't have anything like that so you will have to write your own. Check out this article:

http://weblogs.sqlteam.com/jeffs/archive/2004/03/22/sql-server-2000-paging.aspx

I haven't used that, but seemed like it would work.

Regards,

J

 

[diembi]

Hello jshurt,
thanks a lot. Good method.

Regards