Retrieve resultset when scrolling grid

Question

I want to do the following but I don't know how:

- execute the select statement: "select * from firms"
- and binding this dataset to the DataGridView.DataSource component

Those first 2 steps are not a problem, if you retrieve the entiry resultset at once. However I only want to get the first x records from the database (so the other rows aren't send over the network yet) Those records are only retrieved (send over the network connection) if the user scrolls the DataViewGrid. Is this possible with the C# components?

I'll thank you in advance for an answer.