How to change DataTable colums order

Question

Hi all,

How to change Datatable columns oder in c#.

example:

am created sql table type order is Qty,Unit,Id but in program DataTable order is Id,Qty,Unit. In code Behind am directly pass DataTable to sql table type so the table order is different.

DataTable columns are :`Id,Qty,Unit.`  i want this to be  :`Qty,Unit,Id` 

please help

Answer 1

Try to use the DataColumn.SetOrdinal method. For example:

dataTable.Columns["Qty"].SetOrdinal(0);
dataTable.Columns["Unit"].SetOrdinal(1); 

Answer 2

One of the way is creating your own DataTable like,

DataTable dt = new DataTable();

dt.Columns.Add("Qty",typeof(int));
dt.Columns.Add("Unit",typeof(decimal));
dt.Columns.Add("Id",typeof(Guid));

and

foreach(DataRow item in yourDataTable.Rows)
{
object[] row = new object[]
{
item.Qty, //or Convert.ToInt32(item[x]),
item.Unit, //or Convert.ToDecimal(item[y]),
item.Id //or ....
};
dt.Rows.Add(row);
}