''ConnectionState'' ''serializable, flag'

ConnectionState

serializable, flag

System.Data (system.data.dll)

enum

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( )

Part I: ADO.NET Tutorial

Part II: ADO.NET Core Classes

Part III: API Quick Reference

Chapter 32. How to Use This Quick Reference

Chapter 33. Converting from C# to VB Syntax

Chapter 34. The System.Data Namespace

''AcceptRejectRule'' ''serializable'

''CommandBehavior'' ''serializable, flag'

''CommandType'' ''serializable'

''ConnectionState'' ''serializable, flag'

''Constraint'' ''serializable'

''ConstraintCollection'' ''serializable'

''ConstraintException'' ''serializable'

''DataColumn'' ''diposable'

''DataColumnChangeEventArgs'' '''

''DataColumnChangeEventHandler'' ''serializable'

''DataColumnCollection'' ''serializable'

''DataException'' ''serializable'

''DataRelation'' ''serializable'

''DataRelationCollection'' ''serializable'

''DataRow'' ''serializable'

''DataRowAction'' ''serializable, flag'

''DataRowChangeEventArgs'' '''

''DataRowChangeEventHandler'' ''serializable'

''DataRowCollection'' ''serializable'

''DataRowState'' ''serializable, flag'

''DataRowVersion'' ''serializable'

''DataRowView'' '''

''DataSet'' ''serializable, diposable'

''DataSysDescriptionAttribute'' '''

''DataTable'' ''serializable, disposable'

''DataTableCollection'' ''serializable'

''DataView'' ''disposable'

''DataViewManager'' ''disposable'

''DataViewRowState'' ''serializable, flag'

''DataViewSetting'' ''serializable'

''DataViewSettingCollection'' ''serializable'

''DBConcurrencyException'' ''serializable'

''DbType'' ''serializable'

''DeletedRowInaccessibleException'' ''serializable'

''DuplicateNameException'' ''serializable'

''EvaluateException'' ''serializable'

''FillErrorEventArgs'' '''

''FillErrorEventHandler'' ''serializable'

''ForeignKeyConstraint'' ''serializable'

''IColumnMapping'' '''

''IColumnMappingCollection'' '''

''IDataAdapter'' '''

''IDataParameter'' '''

''IDataParameterCollection'' '''

''IDataReader'' ''dispoable'

''IDataRecord'' '''

''IDbCommand'' ''diposable'

''IDbConnection'' ''disposable'

''IDbDataAdapter'' '''

''IDbDataParameter'' '''

''IDbTransaction'' ''disposable'

''InRowChangingEventException'' ''serializable'

''InternalDataCollectionBase'' '''

''InvalidConstraintException'' ''serializable'

''InvalidExpressionException'' ''serializable'

''IsolationLevel'' ''serializable, flag'

''ITableMapping'' '''

''ITableMappingCollection'' '''

''MappingType'' ''serializable'

''MergeFailedEventArgs'' '''

''MergeFailedEventHandler'' ''serializable'

''MissingMappingAction'' ''serializable'

''MissingPrimaryKeyException'' ''serializable'

''MissingSchemaAction'' ''serializable'

''NoNullAllowedException'' ''serializable'

''ParameterDirection'' ''serializable'

''PropertyAttributes'' ''serializable, flag'

''PropertyCollection'' '''

''ReadOnlyException'' ''serializable'

''RowNotInTableException'' ''serializable'

''Rule'' ''serializable'

''SchemaType'' ''serializable'

''SqlDbType'' ''serializable'

''StateChangeEventArgs'' '''

''StateChangeEventHandler'' ''serializable'

''StatementType'' ''serializable'

''StrongTypingException'' ''serializable'

''SyntaxErrorException'' ''serializable'

''TypedDataSetGenerator'' '''

''TypedDataSetGeneratorException'' ''serializable'

''UniqueConstraint'' ''serializable'

''UpdateRowSource'' ''serializable'

''UpdateStatus'' ''serializable'

''VersionNotFoundException'' ''serializable'

''XmlReadMode'' ''serializable'

''XmlWriteMode'' ''serializable'

Chapter 35. The System.Data.Common Namespace

Chapter 36. The System.Data.SqlClient Namespace

Chapter 37. The System.Data.OleDb Namespace

Chapter 38. The System.Data.SqlTypes Namespace

Part IV: Appendixes

Type, Method, Property, and Field Index