How to retrieve results in predefined chunks

Hello,
Let's say I am planning retrieve thousands of records and load them in my
datagrid in a windows form. This is very slow and I want to retrieve the
result in small chunks. For example I want to retrieve first 100 rows and
load it and then when user scrolls down on the grid I retrieve the next 100
rows and so on.
Can anyone give me some hints? Can this be done by writing a SQL statement
or there are other things to take into consideration?
Thanks for your help.http://www.aspfaq.com/show.asp?id=2120
David Portas
SQL Server MVP
--|||Great article thank you very much!
"David Portas" wrote:

> http://www.aspfaq.com/show.asp?id=2120
> --
> David Portas
> SQL Server MVP
> --
>
>