共用方式為


OleDbDataAdapter.DeleteCommand 屬性

定義

取得或設定 SQL 陳述式或預存程序以從資料集中刪除資料錄。

public:
 property System::Data::OleDb::OleDbCommand ^ DeleteCommand { System::Data::OleDb::OleDbCommand ^ get(); void set(System::Data::OleDb::OleDbCommand ^ value); };
public System.Data.OleDb.OleDbCommand? DeleteCommand { get; set; }
[System.Data.DataSysDescription("DbDataAdapter_DeleteCommand")]
public System.Data.OleDb.OleDbCommand DeleteCommand { get; set; }
public System.Data.OleDb.OleDbCommand DeleteCommand { get; set; }
member this.DeleteCommand : System.Data.OleDb.OleDbCommand with get, set
[<System.Data.DataSysDescription("DbDataAdapter_DeleteCommand")>]
member this.DeleteCommand : System.Data.OleDb.OleDbCommand with get, set
Public Property DeleteCommand As OleDbCommand

屬性值

OleDbCommand,用來在 Update(DataSet) 期間刪除資料來源中的資料錄,這些資料錄對應至 DataSet 中刪除的資料列。

屬性

範例

下列範例會 OleDbDataAdapter 建立 並設定 SelectCommandDeleteCommand 屬性。 它假設您已經建立 OleDbConnection 物件。

public static OleDbDataAdapter CreateCustomerAdapter(
    OleDbConnection connection)
{
    OleDbDataAdapter dataAdapter = new OleDbDataAdapter();
    OleDbCommand command;
    OleDbParameter parameter;

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

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

    dataAdapter.SelectCommand = command;

    // Create the DeleteCommand.
    command = new OleDbCommand(
        "DELETE * FROM Customers WHERE CustomerID = ?",
        connection);

    parameter = command.Parameters.Add(
        "CustomerID", OleDbType.Char, 5, "CustomerID");
    parameter.SourceVersion = DataRowVersion.Original;

    dataAdapter.DeleteCommand = command;

    return dataAdapter;
}
Public Shared Function CreateCustomerAdapter( _
    connection As OleDbConnection) As OleDbDataAdapter 

    Dim dataAdapter As New OleDbDataAdapter()
    Dim command As OleDbCommand
    Dim parameter As OleDbParameter

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

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

    dataAdapter.SelectCommand = command

    ' Create the DeleteCommand.
    command = New OleDbCommand( _
        "DELETE * FROM Customers WHERE CustomerID = ?", _
        connection)

    parameter = command.Parameters.Add( _
        "CustomerID", OleDbType.Char, 5, "CustomerID")
    parameter.SourceVersion = DataRowVersion.Original

    dataAdapter.DeleteCommand = command

    Return dataAdapter
End Function

備註

在 期間Update,如果未設定此屬性且主鍵資訊存在於 中DataSet,則如果您設定 SelectCommand 屬性並使用 OleDbCommandBuilderDeleteCommand則會自動產生 。 然後,您未設定的任何其他命令都會由 OleDbCommandBuilder產生。 此產生邏輯需要中 DataSet存在索引鍵數據行資訊。 如需詳細資訊,請參閱使用 CommandBuilder 產生命令

當 指定先前建立OleDbCommand的時DeleteCommandOleDbCommand不會複製 。 會 DeleteCommand 維護先前建立 OleDbCommand 之 對象的參考。

適用於

另請參閱