DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Assync Recordset with ADO Data Control

  1. #1
    Pedro Gonšalves Guest

    Assync Recordset with ADO Data Control


    I have one table in SQL Server with 980.000 records and I used a DAO data
    control linked to a grid to display that information. With this select 'Select
    Id, Title From books', that data control showed same information in a second,
    of course if I scroll the grid I had to wait...
    Now, I using ADO Data Control, but that same select stop the application
    till it has all records from that table, I mean, 2-3 minutes to show samething...
    These any body know any method to do the same thing DAO did?
    Thanks!


  2. #2
    Jeff Binnig Guest

    Re: Assync Recordset with ADO Data Control

    ado data control does not support async record fetching.
    ado recordset's do to some extent. using withevents when you dim an ado rs
    will allow you to use the
    async features.
    --
    -----------------------------------------------------------
    Chemical Information Services, Inc.
    Mailing Address: P.O. Box 743512 Dallas, TX U.S.A 75374
    Corporate Offices: 9550 Forest Lane, Suite 321 Dallas, TX U.S.A. 75243
    Tel: 214-349-6200 Ext. 106 Fax: 214-349-6286
    www.chemicalinfo.com
    Pedro Gonšalves <pedrog@marque.pt> wrote in message
    news:395e3384$1@news.devx.com...
    >
    > I have one table in SQL Server with 980.000 records and I used a DAO data
    > control linked to a grid to display that information. With this select

    'Select
    > Id, Title From books', that data control showed same information in a

    second,
    > of course if I scroll the grid I had to wait...
    > Now, I using ADO Data Control, but that same select stop the application
    > till it has all records from that table, I mean, 2-3 minutes to show

    samething...
    > These any body know any method to do the same thing DAO did?
    > Thanks!
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center