DataTableCollection.Clear Method

Definition

Namespace:

System.Data

Assembly:

System.Data.Common.dll

Source:

DataTableCollection.cs

Clears the collection of all DataTable objects.

public:
 void Clear();

public void Clear ();

member this.Clear : unit -> unit

Public Sub Clear ()

Examples

The following example gets the DataTableCollection of a DataSet, and then clears the collection of all tables.

private void ClearTables()
{
    // Get the DataSet of a DataGrid control.
    DataSet dataSet = (DataSet)DataGrid1.DataSource;
    DataTableCollection tables = dataSet.Tables;

    // Clear the collection.
    tables.Clear();
}

Private Sub ClearTables()
   ' Get the DataSet of a DataGrid control.
   Dim dataSet As DataSet = CType(DataGrid1.DataSource, DataSet)
   Dim tables As DataTableCollection = dataSet.Tables

   ' Clear the collection.
   tables.Clear
End Sub

Remarks

To remove a particular DataTable from the collection, use the Remove method.