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?


Use a for each row in datatable activity

Then inside it use

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


Thanks its working!

1 Like

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