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