IDbConnection.State Property

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Gets the current state of the connection.

Namespace:   System.Data
Assembly:  System.Data (in System.Data.dll)

ReadOnly Property State As ConnectionState

Property Value

Type: System.Data.ConnectionState

One of the ConnectionState values.

The allowed state changes are:

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

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

The following example creates an instance of a derived class, OleDbConnection, sets its ConnectionString, and displays its State.

Public Sub CreateOleDbConnection()
    Dim connection As New OleDbConnection()
    connection.ConnectionString = _
       "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Northwind.mdb"
    Console.WriteLine("Connection State: " & connection.State.ToString())
End Sub

.NET Framework
Available since 1.1
Return to top
Show: