OdbcConnection.State Property

 

Gets the current state of the connection.

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

<BrowsableAttribute(False)>
Public Overrides ReadOnly Property State As ConnectionState

Property Value

Type: System.Data.ConnectionState

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

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.

System_CAPS_noteNote

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.

.NET Framework
Available since 1.1
Return to top
Show: