title: DBGrid with read ahead capability using ADO
body: <p>I'm working with ADO connecting to SQL Server 2005.</p>
  
  <p>My TADODataSet selects 1 million records. using a TDBGrid and setting the <code>TADODataSet.CursorLocation</code> to <code>clUseServer</code> works. but the TDBGrid chokes!</p>
  
  <p>How can I select 1 million records, avoid paging, and still be able to display records in the grid without fetching ALL records to the client side, letting the Grid read ahead as I scroll up and down?</p>
  
  <p>SQL enterprise manager can execute a query and select 1 million records asynchronously without any problems (also MS-ACCESS).</p>