DataTableCollection.Add Method ()

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Creates a new DataTable object by using a default name and adds it to the collection.

Namespace:   System.Data
Assembly:  System.Data (in System.Data.dll)

Public Function Add As DataTable

Return Value

Type: System.Data.DataTable

The newly created DataTable.

Because no name is specified, the DataTable is created by using a default name, relative to its order of addition. The default name is "Table1."

The CollectionChanged event occurs when a table is successfully added to the collection.

The following example adds three new DataTable objects to the DataTableCollection using the Add method without arguments.

Private Sub AddTables()
   Dim table As DataTable

   ' Presuming a DataGrid is displaying more than one table, get its DataSet.
   Dim thisDataSet As DataSet = CType(DataGrid1.DataSource, DataSet)
   Dim i As Integer
   For i = 0 to 2
      thisDataSet.Tables.Add()
   Next i

   Console.WriteLine(thisDataSet.Tables.Count.ToString() & " tables")
   For Each table In thisDataSet.Tables
      Console.WriteLine(table.TableName)
   Next
End Sub

.NET Framework
Available since 1.1
Return to top
Show: