LinQ Query to Update Specific column value for Specific row

[avinash_ghanwat1]

Hi Team, I have Datatable with Column Names “Name” & “Address”, I want to Update Address for name “Avinash” to “India” with the help of LinQ query, I dont want to use For Each in Datatable Activity for the above task.

I have also attached screenshot of the Datatable, Also find below Table structure in case someone Not able to access Image:

Input Datatable:

Name Address
Avinash Thane
Yogesh Kalyan
Sarita Pune

Expected Output Datatable:

Name Address
Avinash India
Yogesh Kalyan
Sarita Pune

[Shiva_Nikhil]

@avinash_ghanwat1

use this in assign activity

datatablevar.rows(0).item("Address")="India"

or

datatablevar.rows(0).item(1)="India"

[ppr (Peter Preuss)]

have a look at the different options for updating a column value
How to Update Data Column Values of a Data Table | Community Blog

As LINQ risks in such a case a more unneeded blackboxing have a look at:
2. Case: update column values on specific data rows

[avinash_ghanwat1]

I know this will work, but lets say we are not sure about at which row “Avinash” name is present in datatable then what could be done?

[Shiva_Nikhil]

@avinash_ghanwat1

dt.asenumerable.any(function(a) a("Name").tostring.equals("Avinash"))

gives you boolen output

gives you the row index and you can pass it in the earlier expression

dt.asenumerable.tolist.findindex(function(a) a("Name").tostring.trim.equals("Avinash"))

[ppr (Peter Preuss)]

@avinash_ghanwat1

at which row “Avinash” name is present in datatable then what could be done?

arrIndexes | int32 Array =

(From i in Enumerable.Range(0,dtData.Rows.Count)
let v = dtData.Rows(i)("Name").toString.Trim
Where v.Equals(strYourCheckVar)
Select x = i).ToArray

with this we could retrieve all relevant row indexes

[Siva_krishna_Thumma]

Hi,

check this approach.

io_Input_DT.AsEnumerable().Select(y=> y).ToList().ForEach(x=>
{
if(x(“Name”).ToString() = “Your condition” )
{
x(“Name”) = x(“Name”).ToString() + " " + x(“Address”).ToString();
}
}
);
io_Input_DT.AcceptChanges();

[avinash_ghanwat1]

Thank you @Shiva_Nikhil I tried & this is working as expected.