OracleConnection.State Properti

Definisi

Ruang nama:

System.Data.OracleClient

Rakitan:

System.Data.OracleClient.dll

Mendapatkan status koneksi saat ini.

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

[System.ComponentModel.Browsable(false)]
public override System.Data.ConnectionState State { get; }

[<System.ComponentModel.Browsable(false)>]
member this.State : System.Data.ConnectionState

Public Overrides ReadOnly Property State As ConnectionState

Nilai Properti

ConnectionState

Kombinasi bitwise dari ConnectionState nilai. Default adalah Closed.

Atribut

BrowsableAttribute

Contoh

Contoh berikut membuat instans kelas turunan, OracleConnection, mengatur ConnectionString, dan menampilkan State.

public void createOracleConnection()
{
    using (OracleConnection connection = new OracleConnection())
    {
        connection.ConnectionString = "Data Source=Oracle8i;Integrated Security=yes";
        connection.Open();
        Console.WriteLine("Connection State: " + connection.State);
    }
}

Public Sub createOracleConnection()
    Using connection As New OracleConnection()
        connection.ConnectionString = _
           "Data Source=Oracle8i;Integrated Security=yes"
        connection.Open()
        Console.WriteLine("Connection State: " & connection.State)
    End Using
End Sub

Keterangan

Perubahan status yang diizinkan adalah:

• Dari Closed ke Open, menggunakan Open metode OracleConnection objek .

• Dari Open ke Closed, menggunakan Close metode OracleConnection objek .