ConnectionState Enum

Definition

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

This enumeration supports a bitwise combination of its member values.

C#
[System.Flags]
public enum ConnectionState
Inheritance
ConnectionState
Attributes

Fields

Name Value Description
Closed 0

The connection is closed.

Open 1

The connection is open.

Connecting 2

The connection object is connecting to the data source.

Executing 4

The connection object is executing a command. (This value is reserved for future versions of the product.)

Fetching 8

The connection object is retrieving data. (This value is reserved for future versions of the product.)

Broken 16

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.)

Remarks

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

备注

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

Applies to

产品 版本
.NET Core 1.0, Core 1.1, Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9, 10
.NET Framework 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard 2.0, 2.1
UWP 10.0