IDbConnection.State 屬性

定義

命名空間:

System.Data

組件:

netstandard.dll, System.Data.Common.dll

來源:

IDbConnection.cs

取得連接的目前狀態。

public:
 property System::Data::ConnectionState State { System::Data::ConnectionState get(); };

public System.Data.ConnectionState State { get; }

member this.State : System.Data.ConnectionState

Public ReadOnly Property State As ConnectionState

屬性值

ConnectionState

這是其中一項 ConnectionState 價值。

範例

以下範例建立導出類別的實例， OleDbConnection，設定其 ConnectionString，並顯示其 State。

public void CreateOleDbConnection(){
   OleDbConnection connection = new OleDbConnection();
   connection.ConnectionString =
       "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Northwind.mdb";
   Console.WriteLine("Connection State: " + connection.State.ToString());
}

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

備註

允許的狀態變更包括：

• 從 Closed 到 Open，使用 Open Connection 物件的方法。

• 從 Open 到 Closed，使用 Connection 物件的方法或CloseDispose方法。