Represents the collection of tables for the DataSet.
Namespace:
System.Data
Assembly:
System.Data (in System.Data.dll)
Visual Basic (Declaration)
<ListBindableAttribute(False)> _
Public NotInheritable Class DataTableCollection _
Inherits InternalDataCollectionBase
Dim instance As DataTableCollection
[ListBindableAttribute(false)]
public sealed class DataTableCollection : InternalDataCollectionBase
[ListBindableAttribute(false)]
public ref class DataTableCollection sealed : public InternalDataCollectionBase
public final class DataTableCollection extends InternalDataCollectionBase
The DataTableCollection contains all the DataTable objects for a particular DataSet. To access the DataTableCollection of a DataSet, use the Tables property.
The DataTableCollection uses methods such as Add, Clear, and Remove to manage the items in the collection.
Use the Contains method to determine whether a particular table (specified by either index or name) is in the collection.
To navigate from one table to another, use the ChildRelations or ParentRelations property of the DataTable to access its collection of DataRelation objects. You can also use the Relations property to navigate through the parent/child relationships of the DataTables in a particular DataSet collection.
The first procedure in this example retrieves the DataTableCollection of a DataSet and prints the value of each column, in each row, of each table. The second procedure creates a new DataTable with two columns, and adds it to the DataTableCollection.
Private Sub GetTables(dataSet As DataSet)
' Get Each DataTable in the DataTableCollection and
' print each row value.
Dim table As DataTable
Dim row As DataRow
Dim column As DataColumn
For Each table In dataSet.Tables
For Each row In table.Rows
For Each column in table.Columns
If Not (row(column) Is Nothing) Then
Console.WriteLine(row(column))
End If
Next
Next
Next
End Sub
Private Sub CreateTable(dataSet As DataSet)
Dim newTable As DataTable = new DataTable("table")
newTable.Columns.Add("ID", Type.GetType("System.Int32"))
newTable.Columns.Add("Name", Type.GetType("System.String"))
dataSet.Tables.Add(newTable)
End Sub
private void GetTables(DataSet dataSet)
{
// Get Each DataTable in the DataTableCollection and
// print each row value.
foreach (DataTable table in dataSet.Tables)
foreach (DataRow row in table.Rows)
foreach (DataColumn column in table.Columns)
if (row[column] != null)
Console.WriteLine(row[column]);
}
private void CreateTable(DataSet dataSet)
{
DataTable newTable = new DataTable("table");
newTable.Columns.Add("ID", typeof(int));
newTable.Columns.Add("Name", typeof(string));
dataSet.Tables.Add(newTable);
}
System..::.Object
System.Data..::.InternalDataCollectionBase
System.Data..::.DataTableCollection
This type is safe for multithreaded read operations. You must synchronize any write operations.
Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98, Windows CE, Windows Mobile for Smartphone, Windows Mobile for Pocket PC, Xbox 360, Zune
The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
.NET Framework
Supported in: 3.5, 3.0, 2.0, 1.1, 1.0
.NET Compact Framework
Supported in: 3.5, 2.0, 1.0
XNA Framework
Supported in: 3.0, 2.0, 1.0
Reference