DataTableCollection.AddRange(DataTable[]) 方法

定义

将指定的 DataTable 数组的元素复制到集合末尾。Copies the elements of the specified DataTable array to the end of the collection.

public:
 void AddRange(cli::array <System::Data::DataTable ^> ^ tables);
public void AddRange (System.Data.DataTable?[]? tables);
public void AddRange (System.Data.DataTable[] tables);
member this.AddRange : System.Data.DataTable[] -> unit
Public Sub AddRange (tables As DataTable())

参数

tables
DataTable[]

要添加到集合中的 DataTable 对象的数组。The array of DataTable objects to add to the collection.

示例

下面的示例创建两个 DataTable 对象,并将它们添加到的 DataTableCollection DataSetThe following example creates two DataTable objects and adds them to the DataTableCollection of a DataSet.

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();
    }
}
Public Sub DataTableCollectionAddRange()
    ' create a DataSet with two tables
    Dim dataSet As New DataSet()

    ' create Customer table
    Dim customersTable As New DataTable("Customers")
    customersTable.Columns.Add("customerId", _
           Type.GetType("System.Int32")).AutoIncrement = True
    customersTable.Columns.Add("name", Type.GetType("System.String"))
    customersTable.PrimaryKey = New DataColumn() _
           {customersTable.Columns("customerId")}

    ' create Orders table
    Dim ordersTable As New DataTable("Orders")
    ordersTable.Columns.Add("orderId", _
           Type.GetType("System.Int32")).AutoIncrement = True
    ordersTable.Columns.Add("customerId", _
           Type.GetType("System.Int32"))
    ordersTable.Columns.Add("amount", _
           Type.GetType("System.Double"))
    ordersTable.PrimaryKey = New DataColumn() _
           {ordersTable.Columns("orderId")}

    dataSet.Tables.AddRange(New DataTable() {customersTable, ordersTable})

    ' print the tables and their columns
    Dim table As DataTable
    Dim column As DataColumn
    For Each table In dataSet.Tables
        Console.WriteLine(table.TableName)
        For Each column In table.Columns
            Console.Write("{0}" & vbTab, column.ColumnName)
        Next
        Console.WriteLine()
    Next
End Sub

适用于