DbDataAdapter.DeleteCommand Proprietà

Definizione

Ottiene o imposta un comando per l'eliminazione di record dal set di dati.Gets or sets a command for deleting records from the data set.

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

Valore della proprietà

DbCommand

Interfaccia IDbCommand utilizzata durante l'utilizzo del metodo Update(DataSet) per eliminare i record nell'origine dati relativi alle righe eliminate dal set di dati.An IDbCommand used during Update(DataSet) to delete records in the data source for deleted rows in the data set.

Attributi

Esempio

Nell'esempio seguente viene creata la classe derivata OleDbDataAdapter e vengono impostate alcune delle relative proprietà.The following example creates the derived class OleDbDataAdapter and sets some of its properties.

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

Commenti

Durante Update , se questa proprietà non è impostata e le informazioni sulla chiave primaria sono presenti in DataSet , DeleteCommand viene generato automaticamente.During Update, if this property is not set and primary key information is present in the DataSet, the DeleteCommand is automatically generated.

Si applica a

Vedi anche