OdbcConnection.ChangeDatabase(String) Metode

Definisi

Ruang nama:

System.Data.Odbc

Rakitan:

System.Data.Odbc.dll

Paket:

System.Data.Odbc v9.0.0-preview.5.24306.7

Sumber:

OdbcConnection.cs

Mengubah database saat ini yang terkait dengan pembukaan OdbcConnection.

public:
 override void ChangeDatabase(System::String ^ value);

public override void ChangeDatabase (string value);

override this.ChangeDatabase : string -> unit

Public Overrides Sub ChangeDatabase (value As String)

Parameter

value

String

Nama database.

Pengecualian

ArgumentException

Nama database tidak valid.

InvalidOperationException

Koneksi tidak terbuka.

OdbcException

Tidak dapat mengubah database.

Contoh

Contoh berikut membuat OdbcConnection dan mengubah database saat ini.

private static void CreateOdbcConnection()
{
    string connectionString = "Driver={SQL Native Client};Server=(local);Trusted_Connection=Yes;Database=AdventureWorks;";

    using (OdbcConnection connection = new OdbcConnection(connectionString))
    {
        connection.Open();
        Console.WriteLine("ServerVersion: " + connection.ServerVersion
            + "\nDatabase: " + connection.Database);
        connection.ChangeDatabase("master");
        Console.WriteLine("ServerVersion: " + connection.ServerVersion
            + "\nDatabase: " + connection.Database);
        Console.ReadLine();
    }
}

Private Sub CreateOdbcConnection()

    Dim connectionString As String = _
       "Driver={SQL Native Client};Server=(local);Trusted_Connection=Yes;Database=AdventureWorks;"

    Using connection As New OdbcConnection(connectionString)
        With connection
            .Open()
            Console.WriteLine("ServerVersion: " & .ServerVersion _
               & vbCrLf + "Database: " & .Database)
            .ChangeDatabase("master")
            Console.WriteLine("ServerVersion: " & .ServerVersion _
               & vbCrLf + "Database: " & .Database)
            Console.ReadLine()
        End With
    End Using
End Sub

Keterangan

Parameter value harus berisi nama database yang valid, dan tidak boleh berisi nilai null, string kosong (""), atau string dengan karakter kosong saja.

Lihat juga

• Menyambungkan ke Sumber Data