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 Sub ClearDataSet(ByVal dataSet As DataSet) ' To test, print the number rows in each table. Dim table As DataTable For Each table In dataSet.Tables Console.WriteLine(table.TableName & "Rows.Count = " _ & table.Rows.Count.ToString()) Next ' Clear all rows of each table. dataSet.Clear() ' Print the number of rows again. For Each table In dataSet.Tables Console.WriteLine(table.TableName & "Rows.Count = " _ & table.Rows.Count.ToString()) Next End Sub
.NET Framework
Available since 1.1
Available since 1.1
Show: