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

  • Thread starter Thread starter Agnes
  • Start date Start date
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
 
Back
Top