Update datatable using Linq

[Kapil (Kapil Parmar)]

Hi,

I am having a datatable similar to below. I want to update the “Company” column for row where Id = 2 to “TCS”. Is it possible to do it using Linq or any other method apart from using iteration?

Thanks!

[ppr (Peter Preuss)]

How to Update Data Column Values of a Data Table | Community Blog

[Anil_G (Anil Gorthi)]

@Kapil

Use invoke code with below and send dt and in/out

Dt.AsEnumerable.Where(function(x) x("id").ToString.Equals("2")).ToList.ForEach(sub(r) r("Company") = "TCS")

Cheers

[sasi_poosarla (sasi p)]

@Kapil
through invoke activity can do!!

For Each row As DataRow In dt.AsEnumerable
If(row(0).ToString=“2”) Then
row(1)=“Tcs”
End If
next

Cheers!!