Insert a Column in DataTable at Predefined Position

If we want to add a column in a table at a particular position.

To do this task we use the DataTable function SetOrdinal().

For this function we use the namespace:

System.Data;

We have a DataTable with some columns:

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.

Now the table structure will be:

ID

FirstName

LastName

LastName

PhoneNo

Address

City