DataTable.RowDeleting Event

Definition

Namespace:

System.Data

Assemblies:

netstandard.dll, System.Data.Common.dll

Source:

DataTable.cs

Occurs before a row in the table is about to be deleted.

C#

public event System.Data.DataRowChangeEventHandler? RowDeleting;

Event Type

DataRowChangeEventHandler

Examples

C#

private static void DataTableRowDeleting()
{
    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 RowDeleting event handler for the table.
    customerTable.RowDeleting += new DataRowChangeEventHandler( Row_Deleting );

    // 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_Deleting( object sender,
    DataRowChangeEventArgs e )
{
    Console.WriteLine( "Row_Deleting Event: name={0}; action={1}",
        e.Row["name"], e.Action );
}

Remarks

For more information, see Handling DataTable Events.

Applies to

See also

• DataTables