OracleConnection.State Property

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Gets the current state of the connection.

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

[BrowsableAttribute(false)]
public override ConnectionState State { get; }

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

.NET Framework
Available since 1.1
Return to top
Show: