I have a store procedure that can take like 10 - 15 minutes.
I want to execute the SP in a Thread, because the user can cancel the query.
I try with Dim MyThread As New Thread(AddressOf runQuery)
So i put a start button (MyThread.Start()) an a cancel but (MyThread.Abort(),, i guest...)
My query runs fine, but i can't cancel de thread..
I'm using ASP.NET, with a SQL Server 2000 DB. And a WebService have the logic of the app...
WebForm -> WService -> VB Class -> DB
Any help please?