DbDataAdapter.DeleteCommand Propriedade

Definição

Espaço de Nomes:
System.Data.Common
Assemblagem:
System.Data.dll
Assemblagem:
netstandard.dll

Recebe ou define um comando para eliminar registos do conjunto de dados.

public:
 property System::Data::Common::DbCommand ^ DeleteCommand { System::Data::Common::DbCommand ^ get(); void set(System::Data::Common::DbCommand ^ value); };
[System.ComponentModel.Browsable(false)]
public System.Data.Common.DbCommand DeleteCommand { get; set; }
[<System.ComponentModel.Browsable(false)>]
member this.DeleteCommand : System.Data.Common.DbCommand with get, set
Public Property DeleteCommand As DbCommand

Valor de Propriedade

DbCommand

An IDbCommand usado durante Update(DataSet) para eliminar registos na fonte de dados para linhas eliminadas no conjunto de dados.

Atributos
BrowsableAttribute

Exemplos

O exemplo seguinte cria a classe OleDbDataAdapter derivada e define algumas das suas propriedades.

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

Observações

Durante Update, se esta propriedade não estiver definida e a informação da chave primária estiver presente no DataSet, o DeleteCommand é gerado automaticamente.

Aplica-se a

Ver também