Does anyone have code on loading data to a datagrid or array from a recordset with the CurserLocation set to adUseServer.???????

i dont want to load all rows because its more than 1000000 records. Just the last 10 and the next hundred, And i t should change while scrolling.