OracleConnection.State Property

Reference

Definition

Namespace:: System.Data.OracleClient

Assembly:: System.Data.OracleClient.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets the current state of the connection.

public:
 property System::Data::ConnectionState State { System::Data::ConnectionState get(); };

public:
 virtual property System::Data::ConnectionState State { System::Data::ConnectionState get(); };

[System.ComponentModel.Browsable(false)]
public System.Data.ConnectionState State { get; }

[System.ComponentModel.Browsable(false)]
public override System.Data.ConnectionState State { get; }

[<System.ComponentModel.Browsable(false)>]
member this.State : System.Data.ConnectionState

Public ReadOnly Property State As ConnectionState

Public Overrides ReadOnly Property State As ConnectionState

Property Value

ConnectionState

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

Implements

State

Attributes: BrowsableAttribute

Examples

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

public void createOracleConnection()
{
    using (OracleConnection connection = new OracleConnection())
    {
        connection.ConnectionString = "Data Source=Oracle8i;Integrated Security=yes";
        connection.Open();
        Console.WriteLine("Connection State: " + connection.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

Remarks

The allowed state changes are:

From Closed to Open, using the Open method of the OracleConnection object.
From Open to Closed, using the Close method of the OracleConnection object.

Applies to

Jaa