Export (0) Print
Expand All

OracleConnection.State Property

Gets the current state of the connection.

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

'Declaration
<BrowsableAttribute(False)> _
Public Overrides ReadOnly Property State As ConnectionState

Property Value

Type: System.Data.ConnectionState
A bitwise combination of the ConnectionState values. The default is Closed.

Implements

IDbConnection.State

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"
        connection.Open()
        Console.WriteLine("Connection State: " & connection.State)
    End Using 
End Sub

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1
Show:
© 2015 Microsoft