c datatable insert column at position 0

Question

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

User · Accepted Answer

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

User · Answer

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

User · Answer

Example to define how to do        DataTable dt   new DataTable            dt Columns Add  quot ID quot        dt Columns Add  quot FirstName quot        dt Columns Add  quot LastName quot        dt Columns Add  quot Address quot        dt Columns Add  quot City quot                   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  quot PhoneNo quot   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#] c# datatable insert column at position 0

Examples related to c#

Examples related to datatable

Examples related to insert

Examples related to position