How to cancel execution of an asynchronously executing SqlCommand?

  • Thread starter Thread starter Henrik Dahl
  • Start date Start date
H

Henrik Dahl

Hello!

ADO.NET 2.0 offers the possibility to execute SqlCommands asynchronously,
for instance SqlCommand.BeginExecuteReader. Let's assume it takes quite some
time to execute such an SqlCommand. Is there a way to cancel the execution
of an SqlCommand executing in this asynchronous manner?


Best regards,

Henrik Dahl
 
Perhaps (only perhaps). When executing some queries against SQL Server, you
have the option of using the SqlCommand.Cancel method--assuming you are
executing the query asynchronously. I discuss this in my book in far more
detail.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
 
Hi Henrik,

yes, as Bill said, SqlCommand.Cancel() is supposed to work in this
situation.

Did you meet any further question? Please feel free to let me know, I'm
glad to assist you.

Have a great day,
Sincerely,
Wen Yuan
 
Hi Henrik,

Have you resolved the issue? I just want to check whether the issue has
been resolved.
Please feel free to let me know if you have any further issue or anything
unclear.

Have a great day,
Sincerely,
Wen Yuan
 
Back
Top