DataTableCollection.AddRange(DataTable[]) Method

Definition

Namespace:

System.Data

Assemblies:

netstandard.dll, System.Data.Common.dll

Source:

DataTableCollection.cs

Copies the elements of the specified DataTable array to the end of the collection.

C#

public void AddRange(System.Data.DataTable?[]? tables);

Parameters

tables

DataTable[]

The array of DataTable objects to add to the collection.

Examples

The following example creates two DataTable objects and adds them to the DataTableCollection of a DataSet.

C#

public static void DataTableCollectionAddRange()
{
    // create a DataSet with two tables
    DataSet dataSet = new DataSet();

    // create Customer table
    DataTable customersTable = new DataTable("Customers");
    customersTable.Columns.Add("customerId",
        typeof(int)).AutoIncrement = true;
    customersTable.Columns.Add("name",
        typeof(string));
    customersTable.PrimaryKey = new DataColumn[] { customersTable.Columns["customerId"] };

    // create Orders table
    DataTable ordersTable = new DataTable("Orders");
    ordersTable.Columns.Add("orderId",
        typeof(int)).AutoIncrement = true;
    ordersTable.Columns.Add("customerId",
        typeof(int));
    ordersTable.Columns.Add("amount",
        typeof(double));
    ordersTable.PrimaryKey = new DataColumn[] { ordersTable.Columns["orderId"] };

    dataSet.Tables.AddRange(new DataTable[] { customersTable, ordersTable });

    // print the tables and their columns
    foreach (DataTable table in dataSet.Tables)
    {
        Console.WriteLine(table.TableName);
        foreach (DataColumn column in table.Columns)
        {
            Console.Write("{0}\table", column.ColumnName);
        }
        Console.WriteLine();
    }
}

Applies to