ConnectionState Enumeration
.NET Framework 2.0
Describes the current state of the connection to a data source.
Assembly: System.Data (in system.data.dll)
This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.
Namespace: System.DataAssembly: System.Data (in system.data.dll)
| Member name | Description | |
|---|---|---|
![]() | 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.) |
![]() | Closed | The connection is closed. |
![]() | Connecting | The connection object is connecting to the data source. (This value is reserved for future versions of the product.) |
![]() | 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.) |
![]() | Open | The connection is open. |
The ConnectionState values are used by the State property of the OleDbConnection and SqlConnection objects.
Windows 98, Windows 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.
Community Additions
ADD
Show:
