Devart Forums

I was wondering if there's a way of quering the database in an asynchronous manner and get the result to my dataset without coding all the related code.

when i use the wizard I get a synchronous code and my application uses a threadpool thus filling up the threadpool with queries waiting for a reply ..

Thank you,
Shy.

Please describe in detail what exactly you need or what is the problem. What asynchronicity do you expect? You need methods BeginFill, EndFill of DataAdapter?

Hi Alexey,

Sorry for the long delay, i recently got back to develop that module i've needed that async methods for.

what i needed was the the begin and end functions for the dataset generated, so every query submitted to the Database would be async (including update, delete and insert), i can do that using the command and conection but not via datasets.

Thanks,
Shy.

Unfortunately, we do not have such functions.

do you plan to have these or any async functions in the future ?

We will consider this possibility.

Thank you.

a background worker component works excellent. You have to code very few lines. Just remember if you are using a data grid view and trying to fill the thread a sync to merge the results into the dataset that is bound to the data grid view.

http://forums.microsoft.com/MSDN/ShowPo ... 2&SiteID=1

take a look at the second to last post on the link above.

Thanks but I need this for a service application with no interface.
the problem is that timeout will not work and some queries just hang.

Shy.

It should still work Import Systems.ComponenetModel then add the event handlers dowork and runworkercompleted manually.