Share via

SqlCeConnection.State Property

  • Article

Gets the current state of the connection.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

Syntax

'Declaration
Public Overrides ReadOnly Property State As ConnectionState
'Usage
Dim instance As SqlCeConnection
Dim value As ConnectionState

value = instance.State

public override ConnectionState State { get; }

public:
virtual property ConnectionState State {
    ConnectionState get () override;
}

/** @property */
public ConnectionState get_State ()

public override function get State () : ConnectionState

Not applicable.

Property Value

A bitwise combination of the ConnectionState values. The default is Closed.

Remarks

The allowed state changes are:

  • From Closed to Open, by using the Open method of the connection object.

  • From Open to Closed, by using either the Close method or the Dispose method of the connection object.

Note

Calling the State property increases application overhead because each call results in a call to the OLE DB DBPROP_CONNECTIONSTATUS property for an open connection.

Platforms

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

Version Information

.NET Framework

Supported in: 3.0

.NET Compact Framework

Supported in: 2.0, 1.0

See Also

Reference

SqlCeConnection Class
SqlCeConnection Members
System.Data.SqlServerCe Namespace