Here is an article:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconpagingthroughqueryresult.asp



>Hi,
>I'm setting up lookup screens on forms and I'd like to limit the number of records retrieved, and have a "More..." button to retrieve the next group, etc. The fields and operators searched on are selected from combo boxes. The first batch of records I'm limiting with a TOP clause.
>
>I'm trying to rotate the next sets of records thru the dataset with the fill command that limits the number of records retrieved. The protected fill method with the signature
>(Dataset, integer, integer, string, ldbcommand, commandbehavior) would be useful, but apparently is not accessible, since it's in an abstract class only.
>
>I'm sure limiting the number of records retrieved is a common problem in client server, so can someone give me an example of how to bring records down in chunks, or tell me how to use the above fill method?
>
>TIA.