Member Avatar for Finarfin34

Hi everyone!
I have a query that take 5-10 minutes to run. And I use this query in ASP.NET Web Application. How can I manage to cancel query?

For clarification lets say 2 buttons are on the form,one for starting and other for cancelling the query,is it possible if so how can I do?

Thanks in advance!

  • 2 Contributors
  • 1 Reply
  • 93 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by Momerath
Member Avatar for Momerath

Use the BeginExecuteXXX methods (and EndExecuteXXX) of the SQLCommand object. Not sure how you'll handle keeping the query state between pages, though.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.