DataTable.RowDeleting Event
.NET Framework 4.5
Occurs before a row in the table is about to be deleted.
Assembly: System.Data (in System.Data.dll)
For more information, see Working with 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++)
{
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 );
}
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
