Stopping a Query

[Bill Gower]

I have a program which allows the user to graphically create SQL statements
without having to know SQL. They just drag and drop fields to view, select
criteria and sort order. When the user indicates that they want to execute
a query, I parse the SQL statement to verify correctness and then create a
recordset and assign it to a datagrid for viewing. If the query is taking
too long to run or is retrieving too many records, I would like to have a
button to stop the query. If they click this button, how do I
programmatically stop a query while it is running?

Bill

 

[William \(Bill\) Vaughn]

If you execute the SQL asynchronously you can execute a Cancel method on the
SqlCommand object.
You can also set the CommandTimeout property on the SqlCommand object as
well. As I discuss in the book, not all TSQL can be easily cancelled.

hth

--
____________________________________
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)