OracleConnection.State Property


Gets the current state of the connection.

Namespace:   System.Data.OracleClient
Assembly:  System.Data.OracleClient (in System.Data.OracleClient.dll)

Public Overrides ReadOnly Property State As ConnectionState

Property Value

Type: System.Data.ConnectionState

A bitwise combination of the ConnectionState values. The default is Closed.

The allowed state changes are:

The following example creates an instance of a derived class, OracleConnection, sets its ConnectionString, and displays its State.

Public Sub createOracleConnection()
    Using connection As New OracleConnection()
        connection.ConnectionString = _
           "Data Source=Oracle8i;Integrated Security=yes"
        Console.WriteLine("Connection State: " & connection.State)
    End Using
End Sub

.NET Framework
Available since 1.1
Return to top