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.
Copy() creates a new DataTable with the same structure and data as the original DataTable. To copy the structure to a new DataTable, but not the data, use Clone().
Try to use
myTable = table.Clone()
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With