Data ADO.net Question

[maxiachun]

When i use Dataadapter to fill datatable, if the data amount is huge, the user has to wait for a long time, so maybe they want to cancel that operation, how to do that ? SqldataAdapter.fill(mydataset.mydatatable) how to stop this operation I am Entry level person

[Dave Kreskowiak]

You can't. Since this code is most probably executing on the UI thread, you'll notice it's a blocking call and won't return execution to the next line until this query finishes. If you can't execute any code on that thread, there's no way you can click on a button, let alone make this call stop. The only way to "stop" this call is to run the query on a background thread, freeing the UI thread to do other things. To cancel this query, all you have to do is ignore the return from the query thread. Threading is by no means an entry-level thing to put together. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

[maxiachun]

i used mydataAdapter.selectcommand.cancel to cancel that operation. it returns a error which is cancelbyuser sqlexeption I am Entry level person

[Dave Kreskowiak]

SqlCommand.Cancel[^] docs with an example. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome