OdbcConnection.State Property

Definition

Gets the current state of the connection.

public:
 virtual property System::Data::ConnectionState State { System::Data::ConnectionState get(); };
public:
 property System::Data::ConnectionState State { System::Data::ConnectionState get(); };
[System.ComponentModel.Browsable(false)]
public override System.Data.ConnectionState State { get; }
[System.ComponentModel.Browsable(false)]
public System.Data.ConnectionState State { get; }
[<System.ComponentModel.Browsable(false)>]
member this.State : System.Data.ConnectionState
Public Overrides ReadOnly Property State As ConnectionState
Public ReadOnly Property State As ConnectionState

Property Value

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

Implements

Attributes

Remarks

The following are allowed state changes:

  • From Closed to Open, using the Open method.

  • From Open to Closed, using either the Close or Dispose method.

Note

Calling the State property on an open connection increases application overhead because each such call causes a SQL_ATTR_CONNECTION_DEAD call to the underlying ODBC driver to determine whether the connection is still valid.

Applies to

See also