Question How to monitor if datatable is still being "filled" from data adapter.

[kurthack]

I am filling a datatable contained within a dataset from a datadapter in a separate thread. What I want to do is see if this datatable is still being "filled" so that I wait until its done before I call upon it from the primary thread. Is there a status in the datatable that shows that it is still being filled that I can check for? My alternatives are to have a switch at the beginning and end of the routine that I monitor instead or simply monitor the spawned thread. Thoughts?

-Kurt

 

[cjard]

Use a backgroundWorker - you can configure it to raise an event when the operation finishes. Typically there is no good way of checking the progress of a database select operation. For an op that takes an hour, 59 minutes of it might be the database assembling data in memory ready to transmit across the network in the final minute..