Export (0) Print
Expand All
Expand Minimize
1 out of 1 rated this helpful - Rate this topic

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)

[FlagsAttribute] 
public enum ConnectionState
/** @attribute FlagsAttribute() */ 
public enum ConnectionState
FlagsAttribute 
public enum ConnectionState
 Member nameDescription
Supported by the .NET Compact 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 .NET Compact FrameworkClosedThe connection is closed. 
Supported by the .NET Compact FrameworkConnectingThe connection object is connecting to the data source. (This value is reserved for future versions of the product.)  
Supported by the .NET Compact FrameworkExecutingThe connection object is executing a command. (This value is reserved for future versions of the product.)  
Supported by the .NET Compact FrameworkFetchingThe connection object is retrieving data. (This value is reserved for future versions of the product.)  
Supported by the .NET Compact 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.

Windows 98, Windows Server 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 Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 2.0, 1.0

XNA Framework

Supported in: 1.0
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.