DataTable.RowDeleted Event


The .NET API Reference documentation has a new home. Visit the .NET API Browser on to see the new experience.

Occurs after a row in the table has been deleted.

Namespace:   System.Data
Assembly:  System.Data (in System.Data.dll)

public event DataRowChangeEventHandler RowDeleted

For more information, see Handling DataTable Events.

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++)
            new object[] { id, string.Format("customer{0}", id), 
            string.Format("address{0}", id) });


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

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);

.NET Framework
Available since 1.1
Return to top