OdbcDataAdapter Konstruktor

Definisi

Ruang nama:: System.Data.Odbc

Rakitan:: System.Data.Odbc.dll

Rakitan:: System.Data.dll

Paket:: System.Data.Odbc v11.0.0-preview.2.26159.112

Penting

Beberapa informasi terkait produk prarilis yang dapat diubah secara signifikan sebelum dirilis. Microsoft tidak memberikan jaminan, tersirat maupun tersurat, sehubungan dengan informasi yang diberikan di sini.

Menginisialisasi instans baru dari kelas OdbcDataAdapter.

Overload

Nama	Deskripsi
OdbcDataAdapter()	Menginisialisasi instans baru dari kelas OdbcDataAdapter.
OdbcDataAdapter(OdbcCommand)	Menginisialisasi instans OdbcDataAdapter baru kelas dengan pernyataan SQL SELECT yang ditentukan.
OdbcDataAdapter(String, OdbcConnection)	Menginisialisasi instans OdbcDataAdapter baru kelas dengan pernyataan SQL SELECT dan OdbcConnection.
OdbcDataAdapter(String, String)	Menginisialisasi instans OdbcDataAdapter baru kelas dengan pernyataan SQL SELECT dan string koneksi.

OdbcDataAdapter()

Sumber:: OdbcDataAdapter.cs

Sumber:: OdbcDataAdapter.cs

Sumber:: OdbcDataAdapter.cs

Sumber:: OdbcDataAdapter.cs

Menginisialisasi instans baru dari kelas OdbcDataAdapter.

public:
 OdbcDataAdapter();

public OdbcDataAdapter();

Public Sub New ()

Contoh

Contoh berikut membuat OdbcDataAdapter dan mengatur beberapa propertinya.

public static OdbcDataAdapter CreateDataAdapter(
    OdbcConnection connection)
{
    string selectCommand =
        "SELECT CustomerID, CompanyName FROM Customers";

    OdbcDataAdapter adapter = new OdbcDataAdapter(
        selectCommand, connection);
    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

    // Create the Insert, Update and Delete commands.
    adapter.InsertCommand = new OdbcCommand(
        "INSERT INTO Customers (CustomerID, CompanyName) " +
        "VALUES (?, ?)");

    adapter.UpdateCommand = new OdbcCommand(
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " +
        "WHERE CustomerID = ?");

    adapter.DeleteCommand = new OdbcCommand(
        "DELETE FROM Customers WHERE CustomerID = ?");

    // Create the parameters.
    adapter.InsertCommand.Parameters.Add("@CustomerID",
        OdbcType.Char, 5, "CustomerID");
    adapter.InsertCommand.Parameters.Add("@CompanyName",
        OdbcType.VarChar, 40, "CompanyName");

    adapter.UpdateCommand.Parameters.Add("@CustomerID",
        OdbcType.Char, 5, "CustomerID");
    adapter.UpdateCommand.Parameters.Add("@CompanyName",
        OdbcType.VarChar, 40, "CompanyName");
    adapter.UpdateCommand.Parameters.Add("@oldCustomerID",
        OdbcType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    adapter.DeleteCommand.Parameters.Add("@CustomerID",
        OdbcType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    return adapter;
}

Public Function CreateDataAdapter( _
    ByVal connection As OdbcConnection) As OdbcDataAdapter

    Dim selectCommand As String = _
        "SELECT CustomerID, CompanyName FROM Customers"
    Dim adapter As OdbcDataAdapter = _
        New OdbcDataAdapter(selectCommand, connection)

    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey

    ' Create the Insert, Update and Delete commands.
    adapter.InsertCommand = New OdbcCommand( _
        "INSERT INTO Customers (CustomerID, CompanyName) " & _
         "VALUES (?, ?)")

    adapter.UpdateCommand = New OdbcCommand( _
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " & _
        "WHERE CustomerID = ?")

    adapter.DeleteCommand = New OdbcCommand( _
        "DELETE FROM Customers WHERE CustomerID = ?")

    ' Create the parameters.
    adapter.InsertCommand.Parameters.Add( _
        "@CustomerID", OdbcType.Char, 5, "CustomerID")
    adapter.InsertCommand.Parameters.Add( _
        "@CompanyName", OdbcType.VarChar, 40, "CompanyName")

    adapter.UpdateCommand.Parameters.Add( _
        "@CustomerID", OdbcType.Char, 5, "CustomerID")
    adapter.UpdateCommand.Parameters.Add( _
        "@CompanyName", OdbcType.VarChar, 40, "CompanyName")
    adapter.UpdateCommand.Parameters.Add( _
        "@oldCustomerID", OdbcType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    adapter.DeleteCommand.Parameters.Add( _
        "@CustomerID", OdbcType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    Return adapter
End Function

Keterangan

Saat Anda membuat instans OdbcDataAdapter, properti tulis-saja dan baca-saja berikut diatur ke nilai defaultnya, seperti yang ditunjukkan dalam tabel.

Karakteristik	Nilai standar
MissingMappingAction	`MissingMappingAction.Passthrough`
MissingSchemaAction	`MissingSchemaAction.Add`

Anda dapat mengubah nilai salah satu properti ini melalui panggilan terpisah ke properti .

Lihat juga

DataAdapters dan DataReaders

Berlaku untuk

OdbcDataAdapter(OdbcCommand)

Sumber:: OdbcDataAdapter.cs

Sumber:: OdbcDataAdapter.cs

Sumber:: OdbcDataAdapter.cs

Sumber:: OdbcDataAdapter.cs

Menginisialisasi instans OdbcDataAdapter baru kelas dengan pernyataan SQL SELECT yang ditentukan.

public:
 OdbcDataAdapter(System::Data::Odbc::OdbcCommand ^ selectCommand);

public OdbcDataAdapter(System.Data.Odbc.OdbcCommand? selectCommand);

public OdbcDataAdapter(System.Data.Odbc.OdbcCommand selectCommand);

new System.Data.Odbc.OdbcDataAdapter : System.Data.Odbc.OdbcCommand -> System.Data.Odbc.OdbcDataAdapter

Public Sub New (selectCommand As OdbcCommand)

Parameter

selectCommand: OdbcCommand

Yang OdbcCommand merupakan pernyataan SQL SELECT atau prosedur tersimpan, dan ditetapkan sebagai SelectCommand properti .OdbcDataAdapter

Contoh

Contoh berikut membuat OdbcDataAdapter dan mengatur beberapa propertinya.

public static OdbcDataAdapter CreateDataAdapter(
    OdbcConnection connection)
{
    string selectCommand =
        "SELECT CustomerID, CompanyName FROM Customers";

    OdbcDataAdapter adapter = new OdbcDataAdapter(
        selectCommand, connection);
    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

    // Create the Insert, Update and Delete commands.
    adapter.InsertCommand = new OdbcCommand(
        "INSERT INTO Customers (CustomerID, CompanyName) " +
        "VALUES (?, ?)");

    adapter.UpdateCommand = new OdbcCommand(
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " +
        "WHERE CustomerID = ?");

    adapter.DeleteCommand = new OdbcCommand(
        "DELETE FROM Customers WHERE CustomerID = ?");

    // Create the parameters.
    adapter.InsertCommand.Parameters.Add("@CustomerID",
        OdbcType.Char, 5, "CustomerID");
    adapter.InsertCommand.Parameters.Add("@CompanyName",
        OdbcType.VarChar, 40, "CompanyName");

    adapter.UpdateCommand.Parameters.Add("@CustomerID",
        OdbcType.Char, 5, "CustomerID");
    adapter.UpdateCommand.Parameters.Add("@CompanyName",
        OdbcType.VarChar, 40, "CompanyName");
    adapter.UpdateCommand.Parameters.Add("@oldCustomerID",
        OdbcType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    adapter.DeleteCommand.Parameters.Add("@CustomerID",
        OdbcType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    return adapter;
}

Public Function CreateDataAdapter( _
    ByVal connection As OdbcConnection) As OdbcDataAdapter

    Dim selectCommand As String = _
        "SELECT CustomerID, CompanyName FROM Customers"
    Dim adapter As OdbcDataAdapter = _
        New OdbcDataAdapter(selectCommand, connection)

    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey

    ' Create the Insert, Update and Delete commands.
    adapter.InsertCommand = New OdbcCommand( _
        "INSERT INTO Customers (CustomerID, CompanyName) " & _
         "VALUES (?, ?)")

    adapter.UpdateCommand = New OdbcCommand( _
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " & _
        "WHERE CustomerID = ?")

    adapter.DeleteCommand = New OdbcCommand( _
        "DELETE FROM Customers WHERE CustomerID = ?")

    ' Create the parameters.
    adapter.InsertCommand.Parameters.Add( _
        "@CustomerID", OdbcType.Char, 5, "CustomerID")
    adapter.InsertCommand.Parameters.Add( _
        "@CompanyName", OdbcType.VarChar, 40, "CompanyName")

    adapter.UpdateCommand.Parameters.Add( _
        "@CustomerID", OdbcType.Char, 5, "CustomerID")
    adapter.UpdateCommand.Parameters.Add( _
        "@CompanyName", OdbcType.VarChar, 40, "CompanyName")
    adapter.UpdateCommand.Parameters.Add( _
        "@oldCustomerID", OdbcType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    adapter.DeleteCommand.Parameters.Add( _
        "@CustomerID", OdbcType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    Return adapter
End Function

Keterangan

Implementasi OdbcDataAdapter konstruktor ini mengatur SelectCommand properti ke nilai yang ditentukan dalam selectCommand parameter .

Saat Anda membuat instans OdbcDataAdapter, properti tulis-saja dan baca-saja berikut diatur ke nilai defaultnya, seperti yang ditunjukkan dalam tabel.

Karakteristik	Nilai awal
MissingMappingAction	`MissingMappingAction.Passthrough`
MissingSchemaAction	`MissingSchemaAction.Add`

Anda dapat mengubah nilai salah satu properti ini melalui panggilan terpisah ke properti .

Lihat juga

DataAdapters dan DataReaders

Berlaku untuk

OdbcDataAdapter(String, OdbcConnection)

Sumber:: OdbcDataAdapter.cs

Sumber:: OdbcDataAdapter.cs

Sumber:: OdbcDataAdapter.cs

Sumber:: OdbcDataAdapter.cs

Menginisialisasi instans OdbcDataAdapter baru kelas dengan pernyataan SQL SELECT dan OdbcConnection.

public:
 OdbcDataAdapter(System::String ^ selectCommandText, System::Data::Odbc::OdbcConnection ^ selectConnection);

public OdbcDataAdapter(string? selectCommandText, System.Data.Odbc.OdbcConnection? selectConnection);

public OdbcDataAdapter(string selectCommandText, System.Data.Odbc.OdbcConnection selectConnection);

new System.Data.Odbc.OdbcDataAdapter : string * System.Data.Odbc.OdbcConnection -> System.Data.Odbc.OdbcDataAdapter

Public Sub New (selectCommandText As String, selectConnection As OdbcConnection)

Parameter

selectCommandText: String

String yang merupakan pernyataan SQL SELECT atau prosedur tersimpan OdbcDataAdapteryang akan digunakan oleh SelectCommand properti .

selectConnection: OdbcConnection

Yang OdbcConnection mewakili koneksi.

Contoh

Contoh berikut membuat OdbcDataAdapter dan mengatur beberapa propertinya.

public static OdbcDataAdapter CreateDataAdapter(
    OdbcConnection connection)
{
    string selectCommand =
        "SELECT CustomerID, CompanyName FROM Customers";

    OdbcDataAdapter adapter = new OdbcDataAdapter(
        selectCommand, connection);
    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

    // Create the Insert, Update and Delete commands.
    adapter.InsertCommand = new OdbcCommand(
        "INSERT INTO Customers (CustomerID, CompanyName) " +
        "VALUES (?, ?)");

    adapter.UpdateCommand = new OdbcCommand(
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " +
        "WHERE CustomerID = ?");

    adapter.DeleteCommand = new OdbcCommand(
        "DELETE FROM Customers WHERE CustomerID = ?");

    // Create the parameters.
    adapter.InsertCommand.Parameters.Add("@CustomerID",
        OdbcType.Char, 5, "CustomerID");
    adapter.InsertCommand.Parameters.Add("@CompanyName",
        OdbcType.VarChar, 40, "CompanyName");

    adapter.UpdateCommand.Parameters.Add("@CustomerID",
        OdbcType.Char, 5, "CustomerID");
    adapter.UpdateCommand.Parameters.Add("@CompanyName",
        OdbcType.VarChar, 40, "CompanyName");
    adapter.UpdateCommand.Parameters.Add("@oldCustomerID",
        OdbcType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    adapter.DeleteCommand.Parameters.Add("@CustomerID",
        OdbcType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    return adapter;
}

Public Function CreateDataAdapter( _
    ByVal connection As OdbcConnection) As OdbcDataAdapter

    Dim selectCommand As String = _
        "SELECT CustomerID, CompanyName FROM Customers"
    Dim adapter As OdbcDataAdapter = _
        New OdbcDataAdapter(selectCommand, connection)

    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey

    ' Create the Insert, Update and Delete commands.
    adapter.InsertCommand = New OdbcCommand( _
        "INSERT INTO Customers (CustomerID, CompanyName) " & _
         "VALUES (?, ?)")

    adapter.UpdateCommand = New OdbcCommand( _
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " & _
        "WHERE CustomerID = ?")

    adapter.DeleteCommand = New OdbcCommand( _
        "DELETE FROM Customers WHERE CustomerID = ?")

    ' Create the parameters.
    adapter.InsertCommand.Parameters.Add( _
        "@CustomerID", OdbcType.Char, 5, "CustomerID")
    adapter.InsertCommand.Parameters.Add( _
        "@CompanyName", OdbcType.VarChar, 40, "CompanyName")

    adapter.UpdateCommand.Parameters.Add( _
        "@CustomerID", OdbcType.Char, 5, "CustomerID")
    adapter.UpdateCommand.Parameters.Add( _
        "@CompanyName", OdbcType.VarChar, 40, "CompanyName")
    adapter.UpdateCommand.Parameters.Add( _
        "@oldCustomerID", OdbcType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    adapter.DeleteCommand.Parameters.Add( _
        "@CustomerID", OdbcType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    Return adapter
End Function

Keterangan

Implementasi ini OdbcDataAdapter dapat berguna dalam aplikasi yang harus memanggil Fill metode untuk dua objek atau lebih OdbcDataAdapter .

Lihat juga

DataAdapters dan DataReaders

Berlaku untuk

OdbcDataAdapter(String, String)

Sumber:: OdbcDataAdapter.cs

Sumber:: OdbcDataAdapter.cs

Sumber:: OdbcDataAdapter.cs

Sumber:: OdbcDataAdapter.cs

Menginisialisasi instans OdbcDataAdapter baru kelas dengan pernyataan SQL SELECT dan string koneksi.

public:
 OdbcDataAdapter(System::String ^ selectCommandText, System::String ^ selectConnectionString);

public OdbcDataAdapter(string? selectCommandText, string? selectConnectionString);

public OdbcDataAdapter(string selectCommandText, string selectConnectionString);

new System.Data.Odbc.OdbcDataAdapter : string * string -> System.Data.Odbc.OdbcDataAdapter

Public Sub New (selectCommandText As String, selectConnectionString As String)

Parameter

selectCommandText: String

String yang merupakan pernyataan SQL SELECT atau prosedur tersimpan OdbcDataAdapteryang akan digunakan oleh SelectCommand properti .

selectConnectionString: String

String koneksi tersebut.

Contoh

Contoh berikut membuat OdbcDataAdapter dan mengatur beberapa propertinya.

public static OdbcDataAdapter CreateDataAdapter(
    OdbcConnection connection)
{
    string selectCommand =
        "SELECT CustomerID, CompanyName FROM Customers";

    OdbcDataAdapter adapter = new OdbcDataAdapter(
        selectCommand, connection);
    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

    // Create the Insert, Update and Delete commands.
    adapter.InsertCommand = new OdbcCommand(
        "INSERT INTO Customers (CustomerID, CompanyName) " +
        "VALUES (?, ?)");

    adapter.UpdateCommand = new OdbcCommand(
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " +
        "WHERE CustomerID = ?");

    adapter.DeleteCommand = new OdbcCommand(
        "DELETE FROM Customers WHERE CustomerID = ?");

    // Create the parameters.
    adapter.InsertCommand.Parameters.Add("@CustomerID",
        OdbcType.Char, 5, "CustomerID");
    adapter.InsertCommand.Parameters.Add("@CompanyName",
        OdbcType.VarChar, 40, "CompanyName");

    adapter.UpdateCommand.Parameters.Add("@CustomerID",
        OdbcType.Char, 5, "CustomerID");
    adapter.UpdateCommand.Parameters.Add("@CompanyName",
        OdbcType.VarChar, 40, "CompanyName");
    adapter.UpdateCommand.Parameters.Add("@oldCustomerID",
        OdbcType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    adapter.DeleteCommand.Parameters.Add("@CustomerID",
        OdbcType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    return adapter;
}

Public Function CreateDataAdapter( _
    ByVal connection As OdbcConnection) As OdbcDataAdapter

    Dim selectCommand As String = _
        "SELECT CustomerID, CompanyName FROM Customers"
    Dim adapter As OdbcDataAdapter = _
        New OdbcDataAdapter(selectCommand, connection)

    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey

    ' Create the Insert, Update and Delete commands.
    adapter.InsertCommand = New OdbcCommand( _
        "INSERT INTO Customers (CustomerID, CompanyName) " & _
         "VALUES (?, ?)")

    adapter.UpdateCommand = New OdbcCommand( _
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " & _
        "WHERE CustomerID = ?")

    adapter.DeleteCommand = New OdbcCommand( _
        "DELETE FROM Customers WHERE CustomerID = ?")

    ' Create the parameters.
    adapter.InsertCommand.Parameters.Add( _
        "@CustomerID", OdbcType.Char, 5, "CustomerID")
    adapter.InsertCommand.Parameters.Add( _
        "@CompanyName", OdbcType.VarChar, 40, "CompanyName")

    adapter.UpdateCommand.Parameters.Add( _
        "@CustomerID", OdbcType.Char, 5, "CustomerID")
    adapter.UpdateCommand.Parameters.Add( _
        "@CompanyName", OdbcType.VarChar, 40, "CompanyName")
    adapter.UpdateCommand.Parameters.Add( _
        "@oldCustomerID", OdbcType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    adapter.DeleteCommand.Parameters.Add( _
        "@CustomerID", OdbcType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    Return adapter
End Function

Keterangan

Kelebihan beban OdbcDataAdapter konstruktor ini menggunakan selectConnectionString parameter untuk mengatur SelectCommand properti. Namun, koneksi tidak terbuka. Anda masih harus membuka koneksi secara eksplisit.

Lihat juga

DataAdapters dan DataReaders

Berlaku untuk

Saran dan Komentar

Apakah halaman ini membantu?

Bagikan melalui

OdbcDataAdapter Konstruktor

Definisi

Overload

OdbcDataAdapter()

Contoh

Keterangan

Lihat juga

Berlaku untuk

OdbcDataAdapter(OdbcCommand)

Parameter

Contoh

Keterangan

Lihat juga

Berlaku untuk

OdbcDataAdapter(String, OdbcConnection)

Parameter

Contoh

Keterangan

Lihat juga

Berlaku untuk

OdbcDataAdapter(String, String)

Parameter

Contoh

Keterangan

Lihat juga

Berlaku untuk

Saran dan Komentar