How to change DataTable columns order

by

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

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

UPDATE: This answer received much more attention than I expected. To avoid confusion and make it easier to use I decided to create an extension method for column ordering in DataTable:

Extension method:

public static class DataTableExtensions
{
    public static void SetColumnsOrder(this DataTable table, params String[] columnNames)
    {
        int columnIndex = 0;
        foreach(var columnName in columnNames)
        {
            table.Columns[columnName].SetOrdinal(columnIndex);
            columnIndex++;
        }
    }
}

Usage:

table.SetColumnsOrder("Qty", "Unit", "Id");

or 

table.SetColumnsOrder(new string[]{"Qty", "Unit", "Id"});

More Related Contents:

  1. How to use Select method of DataTable
  2. Convert generic List/Enumerable to DataTable?
  3. How to read a CSV file into a .NET Datatable
  4. Convert JSON to DataTable
  5. Convert IEnumerable to DataTable
  6. Inner join of DataTables in C#
  7. How To Change DataType of a DataColumn in a DataTable?
  8. Best way to remove duplicate entries from a data table
  9. How can I turn a DataTable to a CSV?
  10. How I can filter a Datatable?
  11. How to select min and max values of a column in a datatable?
  12. How to bind DataTable to Datagrid
  13. Compare two DataTables to determine rows in one but not the other
  14. Export DataTable to Excel File
  15. How to compare 2 dataTables
  16. How to create a DataTable in C# and how to add rows?
  17. Convert DataTable to generic List?
  18. Merge 2 DataTables and store in a new one
  19. DataTable, How to conditionally delete rows
  20. DataTable equivalent in Java [duplicate]
  21. Data is visible in DataSet visualizer but does not show in a DataGrid
  22. Best way to check if a Data Table has a null value in it
  23. Datatable to html Table
  24. Best Practice: Convert LINQ Query result to a DataTable without looping
  25. Get Cell Value from a DataTable in C#
  26. How do I loop through rows with a data reader in C#?
  27. How to Read text file to DataTable [closed]
  28. How to convert DataTable to class Object?
  29. Replacing a DataReader with a DataTable
  30. Convert DataTable to Generic List in C#

Leave a Comment