[How to select certain no of record into a dataset ] ??

A

Agnes

my tables got over 100,000 records (e.g invoice records)
If the user search the 4000th record . invoice number 40000
How can I only return "no.3900 to no.4100" records, but not whole tables,
I need to return 200 records and allow the user move the record position.
E.g the user input no.4000, as he/she press "previous" it will return 3999th
record.

If the dataset return the whole tables, I am afraid it is too slow.
Please Help and give me some advise.
Thanks a lot
From Agnes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataAdapter - select problem 3
How to unit test a Dataset? 1
Finding A Record in a Dataset by index 3
how to invoke a button Click Event programmatically? 8
No Record on the 'one' side 1
How to export a subset of data from a dataset. 2
How to query for Parent Records with no matching Child Record? 1
How do you know if a user had viewed a record? VBA? Access Trigg 3

Top