System.Data.DataTable.Clear Method

Clears the System.Data.DataTable of all data.


public void Clear ()


All rows in all tables are removed. An exception is generated if the table has any enforced child relations that would cause child rows to be orphaned.

If the System.Data.DataSet is bound to an System.Xml.XmlDataDocument, calling DataSet.Clear or DataTable.Clear raises the NotSupportedException. To avoid this situation, traverse each table, removing each row one at a time. When you use DataTable.NewRow to create new rows, the rows must be processed before you call DataTable.Clear.


Namespace: System.Data
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 1.0.5000.0,