DataSet.Clear Metode

  • Referensi

Definisi

Ruang nama:
System.Data
Rakitan:
System.Data.Common.dll
Rakitan:
System.Data.dll
Rakitan:
netstandard.dll
Sumber:
DataSet.cs
Sumber:
DataSet.cs
Sumber:
DataSet.cs

DataSet Menghapus data apa pun dengan menghapus semua baris di semua tabel.

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

Contoh

Contoh berikut menghapus DataSet semua baris di semua tabel.

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

Keterangan

DataSet Jika terikat ke XmlDataDocument, memanggil DataSet.Clear atau DataTable.Clear menaikkan NotSupportedException. Untuk menghindari situasi ini, melintasi setiap tabel, menghapus setiap baris satu per satu.

Berlaku untuk

Lihat juga