Async Middle Tier

Has anyone got an example of an Async middle tier or any example where I can get the logic of how to create an Async middle tier?
I would like to populate a table on my client system with data from a database. I am using ADO to talk to the database, but I would like to be able to get a few rows at a time from the middle tier back to the client so I do not have to freeze the client program to download all the data before I can populate the table.
Any suggestions would be greatly appreciated.
If possible could you email me at [email protected]
Thank you
David Stephen

[Lothar Haensler]

the GetRows method in ADO allows you to specify a number of rows to return. Thus, you can only fetch a few rows and populate your table and continue that process until you get an EOF condition.

ADO 2.0 also support asynchronous execution via the Options Parameter in the Execute method (adAsyncExecute and adAsyncFetch and adAsyncFetchNonBlocking).