Either you use database specific commands, such as TOP x for sql server or
use an overloaded Fill method.
You might read the
Paging Through a Query Result
..net help topic.
--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com www.rthand.com
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.