Used for the IDbConnection.State property, which describes the connection state. Fetching , Executing , Connecting , and Broken aren't currently used by ADO.NET and are included to use when creating a custom provider and for future upgrades to the .NET framework.

public enum ConnectionState {
   Closed = 0x00000000,
   Open = 0x00000001,
   Connecting = 0x00000002,
   Executing = 0x00000004,
   Fetching = 0x00000008,
   Broken = 0x00000010
}

Hierarchy

System.Object System.ValueType System.Enum(System.IComparable, System.IFormattable , System.IConvertible) ConnectionState

Returned By

IDbConnection.State , System.Data.OleDb.OleDbConnection.State , System.Data.OracleClient.OracleConnection.State , System.Data.SqlClient.SqlConnection.State , StateChangeEventArgs.{CurrentState , OriginalState}

Passed To

StateChangeEventArgs.StateChangeEventArgs( )