Hello All,
Am working with the thin client desktop application for "FINANCE CAPITAL MARKETS" using Web services.
As we are keeping database with our end, we are allowing clients to query our database through a query analyzer module which is developed by us, to get required data of theirs need.
So we are forming sql query from our query analyzer module and sending the string to execute in database via web method.
An average query make take several seconds to execute and return dataset. In case of queries having complicated JOINS, which returns huge amount of data may take several minutes to execute.
Let us assume, a client executing a complicated query and waiting for result, In between if he wants to cancel the query execution, I need to give a cancel button in the form..
What I have to do, to cancel the process and cancel the web request and make the application idle.
Please help me. Give idea.
Thanks in advance.
Peer Mohamed Mydeen.