State Property

Gets the current state of the connection.

[Visual Basic]
Public Property State As ConnectionState

[C#]
public ConnectionState State {get; set;}

Return Type

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

Remarks

The allowed state changes are:

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

Example

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

[C#]

public void CreateOracleConnection() 
{ 
  OracleConnection myConnection = new OracleConnection(); 
  myConnection.ConnectionString =  
      "User Id=Scott;Password=tiger;Data Source=Ora"; 
  myConnection.Open(); 
  MessageBox.Show("Connection State: " + myConnection.State.ToString()); 
  myConnection.Close(); 
}

[Visual Basic]

Public Sub CreateOracleConnection()
   Dim myConnection As New OracleConnection()
   myConnection.ConnectionString = _
       "User Id=Scott;Password=tiger;Data Source=Ora"
   myConnection.Open()
   MessageBox.Show("Connection State: " + myConnection.State.ToString())
   myConnection.Close()
 End Sub

See Also

Language

State Property

Return Type

Remarks

Example

See Also