Export (0) Print
Expand All

OracleCommand.Cancel Method

Attempts to cancel the execution of an OracleCommand.

Namespace: System.Data.OracleClient
Assembly: System.Data.OracleClient (in system.data.oracleclient.dll)

'Declaration
Public Overrides Sub Cancel
'Usage
Dim instance As OracleCommand

instance.Cancel
public void Cancel ()
public override function Cancel ()

If there is nothing to cancel, nothing happens. However, if there is a command in process, and the attempt to cancel fails, no exception is generated.

The following example creates an OracleCommand, executes it, then cancels the execution. To accomplish this, the method is passed a string that is an SQL SELECT statement and a string to use to connect to the database.

Public Sub CreateOracleCommand _
(ByVal queryString As String, ByVal connectionString As String)
    Using connection As New OracleConnection(connectionString)
        Dim command As New OracleCommand(queryString, connection)
        command.Connection.Open()
        command.ExecuteReader()
        command.Cancel()
    End Using
End Sub

Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0, 1.1

Community Additions

ADD
Show:
© 2014 Microsoft