Show progress for ADO Recordset Open 
Author Message
 Show progress for ADO Recordset Open

I'm using VB 6.0/ADO to perform ad hoc queries with large resultsets.
As I open a recordset, I would like to show a progress bar to the user,
(e.g. 20% complete, 34% complete, etc...).
Here are my recordset options:
   .CursorLocation = adUseServer
   .Open strSQL, gdbConn, adOpenStatic, adLockReadOnly, adAsyncFetch

I declare my ADO recordset using WithEvents, but I don't get a
FetchProgress event.  I've seen other posts that mention FetchProgress
problems.  It seems that you don't get this event with server side
cursors.

I'm also binding the recordset to a DataGrid 6.0.  (This takes more
time than the recordset.Open method, I think the entire recordset must
be retrieved from the server when you bind it to a DataGrid)

Is there a way to speed up this process?  Or, how can I show a progress
indicator for the "Set DataGrid1.DataSource = madoQueryRS" method?
(I know that you can load a grid very quickly, because MS Access does
this.  It displays the first xxxx number of records, and then if you
scroll down or click "movelast" it takes a while to get to the end.
This gives the user the impression that the load is faster than it
truly is.)

TIA,
Joe

Sent via Deja.com http://www.***.com/
Before you buy.



Tue, 23 Apr 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Open ADO recordset on another ADO recordset - possible?

2. Opening an ADOX Catalog Whilst ADO Recordset is Open

3. ADO fails to release Recordset cursor after opening disconnected Recordset

4. ADO fails to release Recordset cursor after opening disconnected Recordset

5. How to show progressbar while opening recordset ?

6. Opening Recordset from ADTG/XML.......not showing records !!!!!!!!!!!!!!

7. Error Occurs Opening an ADO Recordset from an XML ADO Stream

8. Opening recordsets(OpenRecordset vs. Recordset.Open)

9. Making NULL fields show up when an ADO recordset is saved

10. Show ADO recordset in grid?

11. The progress while opening a recordset...

12. How do I display a progress bar showing progress for database replication


 
Powered by phpBB® Forum Software