DbDataAdapter.SelectCommand Özellik

Tanım

Ad Alanı:

System.Data.Common

Bütünleştirilmiş Kod:

System.Data.Common.dll

Kaynak:

DbDataAdapter.cs

Veri kaynağındaki kayıtları seçmek için kullanılan bir komutu alır veya ayarlar.

public:
 property System::Data::Common::DbCommand ^ SelectCommand { System::Data::Common::DbCommand ^ get(); void set(System::Data::Common::DbCommand ^ value); };

[System.ComponentModel.Browsable(false)]
public System.Data.Common.DbCommand? SelectCommand { get; set; }

[<System.ComponentModel.Browsable(false)>]
member this.SelectCommand : System.Data.Common.DbCommand with get, set

Public Property SelectCommand As DbCommand

Özellik Değeri

DbCommand

IDbCommand sırasında veri kümesine yerleştirilmek üzere veri kaynağından kayıtları seçmek için kullanılanUpdate(DataSet).

Öznitelikler

BrowsableAttribute

Örnekler

Aşağıdaki örnek türetilmiş sınıfı OleDbDataAdapter oluşturur ve bazı özelliklerini ayarlar.

public static OleDbDataAdapter CreateCustomerAdapter(
    OleDbConnection connection)
{
    OleDbDataAdapter adapter = new OleDbDataAdapter();
    OleDbCommand command;

    // Create the SelectCommand.
    command = new OleDbCommand("SELECT * FROM Customers " +
        "WHERE Country = ? AND City = ?", connection);

    command.Parameters.Add("Country", OleDbType.VarChar, 15);
    command.Parameters.Add("City", OleDbType.VarChar, 15);

    adapter.SelectCommand = command;

    // Create the InsertCommand.
    command = new OleDbCommand(
        "INSERT INTO Customers (CustomerID, CompanyName) " +
        "VALUES (?, ?)", connection);

    command.Parameters.Add(
        "CustomerID", OleDbType.Char, 5, "CustomerID");
    command.Parameters.Add(
        "CompanyName", OleDbType.VarChar, 40, "CompanyName");

    adapter.InsertCommand = command;
    return adapter;
}

Public Shared Function CreateCustomerAdapter( _
    connection As OleDbConnection) As OleDbDataAdapter 

    Dim adapter As New OleDbDataAdapter()
    Dim command As OleDbCommand

    ' Create the SelectCommand.
    command = New OleDbCommand("SELECT * FROM Customers " & _
        "WHERE Country = ? AND City = ?", connection)

    command.Parameters.Add("Country", OleDbType.VarChar, 15)
    command.Parameters.Add("City", OleDbType.VarChar, 15)

    adapter.SelectCommand = command

    ' Create the InsertCommand.
    command = New OleDbCommand( _
        "INSERT INTO Customers (CustomerID, CompanyName) " & _
        "VALUES (?, ?)", connection)

    command.Parameters.Add( _
        "CustomerID", OleDbType.Char, 5, "CustomerID")
    command.Parameters.Add( _
        "CompanyName", OleDbType.VarChar, 40, "CompanyName")

    adapter.InsertCommand = command
    Return adapter
End Function

Ayrıca bkz.

• Verileri Düzenleme (ADO.NET)
• DbProviderFactories (ADO.NET)
• ADO.NET’e Genel Bakış