State Property (OracleConnection)
Gets the current state of the connection.
Property Value
A bitwise combination of the
System.Data.ConnectionState values. The default value is Closed.
The following example creates an instance of a derived class,
OracleConnection, sets its
ConnectionString, and displays its
State.
|
|---|
public void CreateOracleConnection()
{
OracleConnection oracleConnection = new OracleConnection();
oracleConnection.ConnectionString =
"User Id=Scott;Password=tiger;Data Source=Ora;";
oracleConnection.Open();
MessageBox.Show("Connection State: " + oracleConnection.State.ToString());
oracleConnection.Close();
} |
|
|---|
Public Sub CreateOracleConnection()
Dim oracleConnection As New OracleConnection()
oracleConnection.ConnectionString = _
"User Id=Scott;Password=tiger;Data Source=Ora;"
oracleConnection.Open()
MessageBox.Show("Connection State: " + oracleConnection.State.ToString())
oracleConnection.Close()
End Sub |