System.Data.ConnectionState Enumeration

Describes the current state of the connection to a data source.

Syntax

[System.Flags]
public enum ConnectionState

Remarks

The System.Data.ConnectionState values are used by the State property of the System.Data.OleDb.OleDbConnection and System.Data.SqlClient.SqlConnection objects.

Note:

The values in this enumeration are not designed to be used as a set of flags.

Members

Member NameDescription
Broken

The connection to the data source is broken. This can occur only after the connection has been opened. A connection in this state may be closed and then re-opened. (This value is reserved for future versions of the product.)

Closed

The connection is closed.

Connecting

The connection object is connecting to the data source.

Executing

The connection object is executing a command. (This value is reserved for future versions of the product.)

Fetching

The connection object is retrieving data. (This value is reserved for future versions of the product.)

Open

The connection is open.

Requirements

Namespace: System.Data
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 1.0.3300.0, 1.0.5000.0, 2.0.0.0