SqlCommand.Cancel for Async Requests

[gilly3]

I have an ASP.NET web Application that uses AJAX Asynchronously to do some
data evaluation. One process involves a very slow stored procedure call.
I give the user a cancel button to stop the AJAX request using
XMLHttp.abort(), but the sql command continues to run.

How can I cancel the request to the database? I see that there is a
SqlCommand.Cancel() method, but how do I get a reference to the correct
SqlCommand?

thanks

-ivan.

 

[William \(Bill\) Vaughn]

1) The Cancel method is more like "RequestCancel". SS won't stop something
until it gets to a "stopping point" where it can roll the operation back.
2) It's only visible on the SqlCommand that launched the query.


--
____________________________________
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.
__________________________________