DataSet.Clear Method

Definition

Namespace:

System.Data

Assemblies:

netstandard.dll, System.Data.Common.dll

Source:

DataSet.cs

Clears the DataSet of any data by removing all rows in all tables.

C#

public void Clear();

Examples

The following example clears the DataSet of all rows in all tables.

C#

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());
    }
}

Remarks

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.

Applies to

See also

• Using DataSets in ADO.NET