Home Library Learn Downloads Support Community
Sign in | United States - English | |
1 out of 1 rated this helpful - Rate this topic

ConnectionState Enumeration

.NET Framework 4

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)
C#
C++
F#
VB
Copy 
[FlagsAttribute]
public enum ConnectionState
Member name Description
Supported by the XNA Framework Closed The connection is closed.
Supported by the XNA Framework Open The connection is open.
Supported by the XNA Framework Connecting The connection object is connecting to the data source. (This value is reserved for future versions of the product.)
Supported by the XNA Framework Executing The connection object is executing a command. (This value is reserved for future versions of the product.)
Supported by the XNA Framework Fetching The connection object is retrieving data. (This value is reserved for future versions of the product.)
Supported by the XNA Framework 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 Note

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

.NET Framework

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

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
Are these flags or not?
This documentation appears to contradict itself, first stating "This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values." And then later noting, "The values in this enumeration are not designed to be used as a set of flags."

Which is it?
History