ADO and the DataGrid
-
Hi, First off, I'm using VC6 with the latest service pack and MDAC 2.6/2.7. I imported the ADO DLL. I have successfully got an app to talk to any database (via a connection string and OLEDB/ODBC) and I can place resulting recordset results into the DataGrid via use of the SetRefDataSource method. However, the DataGrid only accepts the ADO rs if it is disconnected. What I want to do (and I don't know if it's poss, but it sounds like it should be) is to query the database, keep the rs connected, set it into the DataGrid and further results be pulled in as (and when) the user scrolls down the results. I want this as some of our queries take some time and could return millions of rows. It would be nicer to respond quickly pulling back enough data to show in the grid and pull more results as the user scrolls. Is this possible? If so, how might I go about doing it? Thanks, Simon