>When you want to keep the network traffic down, have a grid on a form and fill it with data from a SQL Server table, how many records should you put in it? I do this in VFP with local FoxPro tables, free or hooked to a database, but is this easily done without downloading the entire SQL table to the grid? Or, can you limit the grid to so many records? I know that you can limit how many records you want in the grid, but when the person scrolls, or pages down through the records (or pages up), what do you do to refill the grid when you get near the end of the records you previously queried for?
>
>Well, perhaps my words above don't explain well what I am trying to say. If anyone needs more clarification, just ask. Do you use Fetch to get more records? Or do you just issue a query for a certain range of data?

I think you need to either use some criteria to limit number of records returned or use top (N).