DataSet.Clear 方法

定义

通过移除所有表中的所有行来清除任何数据的 DataSetClears the DataSet of any data by removing all rows in all tables.

public:
 void Clear();
public void Clear ();
member this.Clear : unit -> unit
Public Sub Clear ()

示例

下面的示例将清除所有表中所有行的 DataSetThe 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());
    }
}
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.ClearDataTable.Clear 将引发 NotSupportedExceptionIf 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.

适用于

另请参阅