Hi All,

How can we add a duplicate column to datatable. I already had a column named "Action" in my datatable, and i want a duplicate column to "Action".

Note:
Actually the datatable is being filled from dataset. I cannot change the Sql Query because those are predefined by analysts.

Thanks in advance.

Just use a foreach loop:

dc = new DataColumn("Action2",typeof(string));

ds.Tables[0].Columns.Add(dc);

foreach (DataRow dr in ds.Tables[0].Rows)

{

dr["Action2",]= dr["Action1"];

}

You can not have 2 columns named action in your data table. You canadd a datacolumnthat uses an expression tocopy the data to the new column.

DataColumn dc = new DataColumn("Action2"); dc.Expression = "Action"; dt.Columns.Add(dc);

Hi Ken,

Thank you so much. This was very helpful. But there is one more query in it.

I will change the value of action field when certain key is pressed. But that should not be reflected in 'action2'. Because I want to compare original action and changed action.

Whenver I change the 'action' and click on some other cell, the value of that field is being changed in 'action2' also. That should not happen . Can you please help with this.

Just use a foreach loop:

dc = new DataColumn("Action2",typeof(string));

ds.Tables[0].Columns.Add(dc);

foreach (DataRow dr in ds.Tables[0].Rows)

{

dr["Action2",]= dr["Action1"];

}

Thank you Shin Ye. It worked.