DataRow::Delete Method ()


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

Deletes the DataRow.

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

void Delete()

Exception Condition

The DataRow has already been deleted.

If the RowState of the row is Added, the RowState becomes Detached and the row is removed from the table when you call AcceptChanges.

The RowState becomes Deleted after you use the Delete method on an existing DataRow. It remains Deleted until you call AcceptChanges. At this time, the DataRow is removed from the table.

Delete should not be called in a foreach loop while iterating through a DataRowCollection object. Delete modifies the state of the collection.

A deleted row can be undeleted by invoking RejectChanges.


The BeginEdit method temporarily suspends RowChanging events, but the delete operation does not.

The following example creates a simple DataTable with two columns and ten rows. After deleting several DataRow items with the Delete method, one of the rows is undeleted by invoking RejectChanges.

No code example is currently available or this language may not be supported.

.NET Framework
Available since 1.1
Return to top