3 out of 4 rated this helpful - Rate this topic

DataSet.Tables Property

.NET Framework 4.5

Gets the collection of tables contained in the DataSet.

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

public DataTableCollection Tables { get; }

Property Value

Type: System.Data.DataTableCollection
The DataTableCollection contained by this DataSet. An empty collection is returned if no DataTable objects exist.

Remarks

To add tables to the collection, use Add method of the DataTableCollection. To remove tables, use the Remove method.

Examples

The following example returns the DataSet object's DataTableCollection, and prints the columns and rows in each table.

private void PrintRows(DataSet dataSet)
{
    // For each table in the DataSet, print the row values. 
    foreach(DataTable table in dataSet.Tables)
    {
        foreach(DataRow row in table.Rows)
        {
            foreach (DataColumn column in table.Columns)
            {
                Console.WriteLine(row[column]);
            }
        }
    }
}

Version Information

.NET Framework

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

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Platforms

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.

Reference

DataSet Class

System.Data Namespace

Other Resources

Using DataSets in ADO.NET

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)