Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.5.1, 4.5, 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows Phone 8.1, Windows Phone 8, Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.