LINQ syntax filter and update lines

[pravin_calvin (pravin kumar)]

Hi @drago47

Please use the below Linq Expression

(From d In builDt.AsEnumerable
Let u = If(d(1).toString.Trim.Equals(“B”),“Yes”,“”)
Select DtResult.Rows.Add(New Object(){d(0),d(1),u})).CopyToDataTable

Modified the solution provided by @ppr

And also refer the thread below…

Linq - Update Values in Datatable

Hey, I have 2 different type of changes that I need to do on a datatable Update all specific column values to new value, for example the original datatable A B C 1 3 2 4 the new datatable A B C 1 3 OK 2 4 OK Update column value when the value contain 2 different type of string (I cant use equal), for example if the value in column ‘C’ contain ‘OK’ or contain Value’ to update those row(‘C’) to ‘Done’ I work on big datatable - over 50k rows so I understand the work with linq will…

Refer to the xaml below!
test.xaml (8.2 KB)

Regards