Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Add Method
Collapse the table of content
Expand the table of content

DataTableCollection.Add Method

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)

'Declaration
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

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
Show:
© 2015 Microsoft