Add Data Column After Or Before Specific Column

kuppu_samy · December 23, 2019, 7:08am

Hi Guys,

Does anyone know how to add a column after or before the specific column in DataTable?

AshwinS2 · December 23, 2019, 7:10am

Use insert delete column activity and based on the index value you can create column

Thanks
Ashwin.S

kuppu_samy · December 23, 2019, 7:13am

Yes @AshwinS2 , I can do but I have 50,000 of data in the other columns. I don’t want to delete the existing data.

AshwinS2 · December 23, 2019, 7:15am

Do Insert coulmn and do datatable.clone

Thanks
Ashwin S

kuppu_samy · December 23, 2019, 7:17am

Can you give me some more detailed? Can you give me the code?

hacky · December 23, 2019, 7:29am

You can use Invoke method activity and pass the parameters in the Properties.

You can use the column index number as an argument.

wusiyangjia · December 23, 2019, 7:30am

For example, if you have a DataTable is named dt,
and you hope that a new column “Name” be set before a specific column “Price”.

dt.Columns(“Name”).SetOrdinal(dt.Columns(“Price”).Ordinal)

or if you hope that a new column “Name” be set after a specific column “Price”.

dt.Columns(“Name”).SetOrdinal(dt.Columns(“Price”).Ordinal+1)

system · December 26, 2019, 7:30am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.