DataSet.Clear Method ()
.NET Framework (current version)
Clears the DataSet of any data by removing all rows in all tables.
Assembly: System.Data (in System.Data.dll)
If the DataSet is bound to an XmlDataDocument, calling DataSet.Clear or DataTable.Clear raises the NotSupportedException. To avoid this situation, traverse each table, removing each row one at a time.
The following example clears the DataSet of all rows in all tables.
private void ClearDataSet(DataSet dataSet) { // To test, print the number rows in each table. foreach(DataTable table in dataSet.Tables) { Console.WriteLine(table.TableName + "Rows.Count = " + table.Rows.Count.ToString()); } // Clear all rows of each table. dataSet.Clear(); // Print the number of rows again. foreach(DataTable table in dataSet.Tables) { Console.WriteLine(table.TableName + "Rows.Count = " + table.Rows.Count.ToString()); } }
.NET Framework
Available since 1.1
Available since 1.1
Show: