DataSet.Clear 方法

定义

命名空间:

System.Data

程序集:

System.Data.Common.dll

Source:

DataSet.cs

通过移除所有表中的所有行来清除任何数据的 DataSet。

public:
 void Clear();

public void Clear ();

member this.Clear : unit -> unit

Public Sub Clear ()

示例

以下示例清除 DataSet 所有表中所有行的 。

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

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

注解

DataSet如果 绑定到 ，XmlDataDocument则调用 DataSet.Clear 或 DataTable.Clear 引发 NotSupportedException。 若要避免这种情况，请遍历每个表，一次删除一行。

另请参阅

• 在 ADO.NET 中使用数据集