Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

ConnectionState Enumeration

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)

'Declaration
<FlagsAttribute> _
Public Enumeration ConnectionState

Member nameDescription
Supported by the XNA FrameworkBrokenThe 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.)
Supported by the XNA FrameworkClosedThe connection is closed.
Supported by the XNA FrameworkConnectingThe connection object is connecting to the data source.
Supported by the XNA FrameworkExecutingThe connection object is executing a command. (This value is reserved for future versions of the product.)
Supported by the XNA FrameworkFetchingThe connection object is retrieving data. (This value is reserved for future versions of the product.)
Supported by the XNA FrameworkOpenThe connection is open.

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

NoteNote

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

.NET Framework

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

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
Show:
© 2015 Microsoft