United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

.NET Development

.NET Framework 4.5

.NET Framework Class Library

System.Data Namespaces

System.Data

AcceptRejectRule Enumeration

CommandBehavior Enumeration

CommandType Enumeration

ConflictOption Enumeration

ConnectionState Enumeration

Constraint Class

ConstraintCollection Class

ConstraintException Class

DataColumn Class

DataColumnChangeEventArgs Class

DataColumnChangeEventHandler Delegate

DataColumnCollection Class

DataException Class

DataRelation Class

DataRelationCollection Class

DataRow Class

DataRowAction Enumeration

DataRowBuilder Class

DataRowChangeEventArgs Class

DataRowChangeEventHandler Delegate

DataRowCollection Class

DataRowComparer Class

DataRowComparer(TRow) Class

DataRowExtensions Class

DataRowState Enumeration

DataRowVersion Enumeration

DataRowView Class

DataSet Class

DataSetDateTime Enumeration

DataSetSchemaImporterExtension Class

DataSysDescriptionAttribute Class

DataTable Class

DataTableClearEventArgs Class

DataTableClearEventHandler Delegate

DataTableCollection Class

DataTableExtensions Class

DataTableNewRowEventArgs Class

DataTableNewRowEventHandler Delegate

DataTableReader Class

DataViewManager Class

DataViewRowState Enumeration

DataViewSetting Class

DataViewSettingCollection Class

DBConcurrencyException Class

DbType Enumeration

DeletedRowInaccessibleException Class

DuplicateNameException Class

EntityCommandCompilationException Class

EntityCommandExecutionException Class

EntityException Class

EntityKey Class

EntityKeyMember Class

EntitySqlException Class

EntityState Enumeration

EnumerableRowCollection Class

EnumerableRowCollection(TRow) Class

EnumerableRowCollectionExtensions Class

EvaluateException Class

FillErrorEventArgs Class

FillErrorEventHandler Delegate

ForeignKeyConstraint Class

IColumnMapping Interface

IColumnMappingCollection Interface

IDataAdapter Interface

IDataParameter Interface

IDataParameterCollection Interface

IDataReader Interface

IDataRecord Interface

IDbCommand Interface

IDbConnection Interface

IDbDataAdapter Interface

IDbDataParameter Interface

IDbTransaction Interface

IExtendedDataRecord Interface

InRowChangingEventException Class

InternalDataCollectionBase Class

InvalidCommandTreeException Class

InvalidConstraintException Class

InvalidExpressionException Class

IsolationLevel Enumeration

ITableMapping Interface

ITableMappingCollection Interface

KeyRestrictionBehavior Enumeration

LoadOption Enumeration

MappingException Class

MappingType Enumeration

MergeFailedEventArgs Class

MergeFailedEventHandler Delegate

MetadataException Class

MissingMappingAction Enumeration

MissingPrimaryKeyException Class

MissingSchemaAction Enumeration

NoNullAllowedException Class

ObjectNotFoundException Class

OperationAbortedException Class

OptimisticConcurrencyException Class

OrderedEnumerableRowCollection(TRow) Class

ParameterDirection Enumeration

PropertyAttributes Enumeration

PropertyCollection Class

PropertyConstraintException Class

ProviderIncompatibleException Class

ReadOnlyException Class

RowNotInTableException Class

Rule Enumeration

SchemaSerializationMode Enumeration

SchemaType Enumeration

SerializationFormat Enumeration

SqlDbType Enumeration

StateChangeEventArgs Class

StateChangeEventHandler Delegate

StatementCompletedEventArgs Class

StatementCompletedEventHandler Delegate

StatementType Enumeration

StrongTypingException Class

SyntaxErrorException Class

TypedDataSetGenerator Class

TypedDataSetGeneratorException Class

TypedTableBase(T) Class

TypedTableBaseExtensions Class

UniqueConstraint Class

UpdateException Class

UpdateRowSource Enumeration

UpdateStatus Enumeration

VersionNotFoundException Class

XmlReadMode Enumeration

XmlWriteMode Enumeration

Minimize

1 out of 2 rated this helpful - Rate this topic

ConnectionState Enumeration

.NET Framework 4.5

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

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

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

[FlagsAttribute]
public enum ConnectionState

	Member name	Description
	Closed	The connection is closed.
	Open	The connection is open.
	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.)
	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.)

The ConnectionState values are used by the State property of the OleDbConnection and SqlConnection objects.

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

Version Information

.NET Framework

Supported in: 4.5, 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Reference

System.Data Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.