How to cancel execution of an asynchronously executing SqlCommand?

[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

 

[William \(Bill\) Vaughn]

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)

 

[WenYuan Wang]

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

 

[WenYuan Wang]

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