c# datatable insert column at position 0

Question

does anyone know the best way to insert a column in a datatable at position 0?

sometimes if you are adding column to the datatable after getting the data from db you may need to set it at the begging. — Wael Dalloul, Aug 27 '09 at 09:46
@Stefan, I believe the order of the columns is relevant when using Sql BulkCopy. — IAbstract, Dec 14 '10 at 17:04

Wael Dalloul · Accepted Answer · 2012-11-21T10:24:56.040

205

You can use the following code to add column to Datatable at postion 0:

    DataColumn Col   = datatable.Columns.Add("Column Name", System.Type.GetType("System.Boolean"));
    Col.SetOrdinal(0);// to put the column in position 0;

edited Nov 21 '12 at 10:24

answered Aug 27 '09 at 09:18

Wael Dalloul

22,172
11
48
57

score 107 · Answer 2 · edited Jan 29 '14 at 10:47

107

Just to improve Wael's answer and put it on a single line:

dt.Columns.Add("Better", typeof(Boolean)).SetOrdinal(0);

UPDATE: Note that this works when you don't need to do anything else with the DataColumn. Add() returns the column in question, SetOrdinal() returns nothing.

edited Jan 29 '14 at 10:47

Amit Bisht

4,870
14
54
83

answered Jun 28 '13 at 19:12

CigarDoug

1,438
1
15
29

16

single ligne statement aren't alway better. In this case I like it +1 – Rémi Jul 15 '13 at 15:54

score 3 · Answer 3 · edited Nov 05 '20 at 21:19

    //Example to define how to do :

    DataTable dt = new DataTable();   

    dt.Columns.Add("ID");
    dt.Columns.Add("FirstName");
    dt.Columns.Add("LastName");
    dt.Columns.Add("Address");
    dt.Columns.Add("City");
           //  The table structure is:
            //ID    FirstName   LastName    Address     City

       //Now we want to add a PhoneNo column after the LastName column. For this we use the                               
             //SetOrdinal function, as iin:
        dt.Columns.Add("PhoneNo").SetOrdinal(3);

            //3 is the position number and positions start from 0.`enter code here`

               //Now the table structure will be:
              // ID      FirstName   LastName    PhoneNo    Address     City

c# datatable insert column at position 0

3 Answers3

Linked