Make a new DataTable with the same columns as another DataTable

42,339

Solution 1

Try to use

myTable = table.Clone()

Solution 2

Use the Clone method - it creates a copy of the schema (columns) only.
See DataTable.Clone

Share:
42,339

Related videos on Youtube

John
Author by

John

Updated on March 08, 2020

Comments

  • John
    John over 4 years

    I want to create a new DataTable that has the same columns as another DataTable.

    Currently, I do the following:

    DataTable myTable = new DataTable();
    myTable = table.Copy();
    myTable.Clear();
    

    Then, I import rows into myTable as needed.

    Is there a more efficient way of doing this? Right now if table is large, then there is a lot of unnecessary copying of rows going on.

    Thanks.