DataTable.RowDeleted Event

Definition

Namespace:

System.Data

Assembly:

System.Data.Common.dll

Source:

DataTable.cs

Occurs after a row in the table has been deleted.

public:
 event System::Data::DataRowChangeEventHandler ^ RowDeleted;

public event System.Data.DataRowChangeEventHandler? RowDeleted;

member this.RowDeleted : System.Data.DataRowChangeEventHandler 

Public Custom Event RowDeleted As DataRowChangeEventHandler 

Event Type

DataRowChangeEventHandler

Examples

private static void DataTableRowDeleted()
{
    DataTable customerTable = new DataTable("Customers");
    // add columns
    customerTable.Columns.Add("id", typeof(int));
    customerTable.Columns.Add("name", typeof(string));
    customerTable.Columns.Add("address", typeof(string));

    // set PrimaryKey
    customerTable.Columns[ "id" ].Unique = true;
    customerTable.PrimaryKey = new DataColumn[] { customerTable.Columns["id"] };

    // add a RowDeleted event handler for the table.
    customerTable.RowDeleted += new DataRowChangeEventHandler(Row_Deleted);

    // add ten rows
    for(int id=1; id<=10; id++)
    {
        customerTable.Rows.Add(
            new object[] { id, string.Format("customer{0}", id),
            string.Format("address{0}", id) });
    }

    customerTable.AcceptChanges();

    // Delete all the rows
    foreach(DataRow row in customerTable.Rows)
        row.Delete();
}

private static void Row_Deleted(object sender, DataRowChangeEventArgs e)
{
    Console.WriteLine("Row_Deleted Event: name={0}; action={1}",
        e.Row["name", DataRowVersion.Original], e.Action);
}

Private Sub DataTableRowDeleted()
    Dim customerTable As New DataTable("Customers")
    ' add columns
    customerTable.Columns.Add("id", Type.GetType("System.Int32"))
    customerTable.Columns.Add("name", Type.GetType("System.String"))
    customerTable.Columns.Add("address", Type.GetType("System.String"))

    ' set PrimaryKey
    customerTable.Columns("id").Unique = True
    customerTable.PrimaryKey = New DataColumn() {customerTable.Columns("id")}

    ' add a RowDeleted event handler for the table.
    AddHandler customerTable.RowDeleted, New _
           DataRowChangeEventHandler(AddressOf Row_Deleted)


    ' add ten rows
    Dim id As Integer
    For id = 1 To 10
        customerTable.Rows.Add( _
            New Object() {id, String.Format("customer{0}", id), _
        String.Format("address{0}", id)})
    Next

    customerTable.AcceptChanges()

    ' Delete all the rows
    Dim row As DataRow
    For Each row In customerTable.Rows
        row.Delete()
    Next
End Sub

Private Sub Row_Deleted(ByVal sender As Object, _
ByVal e As DataRowChangeEventArgs)
    Console.WriteLine("Row_Deleted Event: name={0}; action={1}", _
     e.Row("name", DataRowVersion.Original), e.Action)
End Sub

Remarks

For more information, see Handling DataTable Events.

See also

• DataTables