ReArranging DataTables

Question

I have 2 DataTables which have same column names but the order is different how to arrange them in the same order delta_table A B C delta_table_ref B A C output: delta_table_ref A B C

Vulpes · Answer

This should work: int len = delta_table.Columns.Count; for(int i = 0; i { DataColumn dc = delta_table.Columns[i]; for(int j = i; j { DataColumn dcr = delta_table_ref.Columns[j]; if (dcr.ColumnName == dc.ColumnName) { if (i != j) dcr.SetOrdinal(i); break; } } }