I'm querying my Oracle 9i database following the methods in the Data Access Tutorials on www.asp.net (TableAdapter query->BLL->DataTable bound to GridView). I'm also using an UpdatePanel and UpdateProgress for my query.

I have a long running query and I would like to give the user an option to cancel the query. I realize the OracleClient has a .Cancel method for a Command but I'm not directly using and OracleCommand.

How do I go about attempting to cancel my asynchronous query through the TableAdapter safely?

Any help appreciated as usual. Thanks!