DataSet.Clear 方法
定义
public:
void Clear();
public void Clear ();
member this.Clear : unit -> unit
Public Sub Clear ()
示例
下面的示例将清除 DataSet 所有表中所有行的。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());
}
}
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 。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.