I'm using a DataTable
with the contents
column1 column2 column3 column4 column5 column6 column7 column8 column9 column10
row1 a b c d e f g h i j
I want the table to be reorderd as
column4 column2 column1 column7 column6 column9 column10 column5 column8 column3
row1 d b a g f i j e h c
I tried using the DataTable.Column[i].SetOrdinal()
method but it swaps only the first column properly.
Since you haven't shown the full code it's difficult to say what's actually wrong. But this should work:
public static void ReorderTable(ref DataTable table, params String[] columns)
{
if (columns.Length != table.Columns.Count)
throw new ArgumentException("Count of columns must be equal to table.Column.Count", "columns");
for (int i = 0; i < columns.Length; i++)
{
table.Columns[columns[i]].SetOrdinal(i);
}
}
Instead of a params String[]
you could also use a List<DataColumn>
or whatelse you prefer.
Tested with your sample data:
var table = new DataTable();
table.Columns.Add("column1", typeof(string));
table.Columns.Add("column2", typeof(string));
table.Columns.Add("column3", typeof(string));
table.Columns.Add("column4", typeof(string));
table.Columns.Add("column5", typeof(string));
table.Columns.Add("column6", typeof(string));
table.Columns.Add("column7", typeof(string));
table.Columns.Add("column8", typeof(string));
table.Columns.Add("column9", typeof(string));
table.Columns.Add("column10", typeof(string));
for (int i = 0; i < 10; i++)
{
table.Rows.Add("colum1", "column2", "colum3", "column4", "column5", "column6", "column7", "column8", "column9", "column10");
}
ReorderTable(ref table, "column4", "column2", "column1", "column7", "column6", "column9", "column10", "column5", "column8", "column3");
Works already with .NET 2.
int cnt = 0;
foreach (string s in colsList)
{
if (table.Columns.Contains(s))
{
table.Columns[s].SetOrdinal(cnt);
cnt++;
}
}
count need not to be the same.
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