Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
RowDeleting Event

DataTable.RowDeleting Event

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

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

public event DataRowChangeEventHandler RowDeleting

For more information, see Handling DataTable Events.

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

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
© 2015 Microsoft