How to replace the data in data table

Hi all
I want to replace the data in datatable. i have tried following code
"
dtTransaction =dtTransaction.AsEnumerable().Where(Function(a) a.Field(of string)(“RefID”).ToString.Replace(dtTransaction.Rows(i).Item(“RefID”).ToString,dtTestPtAcNo.Rows(i).Item(“PatientAccountNumber”).ToString).ToString).CopyToDataTable()
"
but i got following error


Can anybody fix this error?

@divya.17290

Use a for each row in datatable activity

Then inside it use

Currentrow(“ColumnName”) = whatever value you want to update to

Cheers

Thanks its working!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.