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
Related videos on Youtube
Author by
John
Updated on March 08, 2020Comments
-
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.