LINQ for Adding a Column and Conditionally Populating it with Data

[Lakshay_Verma]

Something like this will work for you
You have to amend as per your requirement
(From dr In dt.AsEnumerable Let newRecord= New Object(){dr(1),“ID”} Select dt.Rows.Add(newRecord)).CopyToDataTable

I took reference from here

Linq - Update Values in Datatable

@noam 1.update new value for all rows in a specific column - for example update all the values in column number 4 (no matter what was the old value) to new value You can play on provided xaml with following (Col 3 is updated with NewValue String) (From d In dtData.AsEnumerable Let ra= New Object(){d(0),d(1),“NewValue”} Select dtResult.Rows.Add(ra)).CopyToDataTable for second request have a look here: Reset_StatusCol_MultiContains_KwordList.xaml (8.0 KB)