Implementation of DataAdapter.SelectCommand.Cancel
--------------------------------------------------
Key: DNET-150
URL: http://tracker.firebirdsql.org/browse/DNET-150
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 2.1.0
Environment: WinXP
Reporter: Chris Wilson
Assignee: Carlos Guzman Alvarez
When I try to invoke this command, I get an error message that it is not
supported. I trap that of course, and just ignore the cancel, so that's the
workaround. However, I've learned that this command can be very useful.
Consider the problem of a long da.fill operation. Normally you start it and
just have to wait. Even if you run it in a background thread, it has to play
out. With the SelectCommand.Cancel (which works for other providers), I can
handle the datatable rowchanged event and look for a global "cancelled"
variable I set elsewhere; if set I issue the SelectCommand.Cancel method and
I'm good to go.
Strongly recommended.
P.S., the command works for OleDB and SQLServer, but it ignored by SQLite.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
