I know the value of ID field. Based on the ID field can I find the row index. So that I can update the status field in the same row.
I know that we can get the value from a different column like this: FinalListLookUpDataTable.Select().Where(function(x) (x(“ID”).ToString = “abc12345”)).First()(“Email Value”).ToString but I want to get the row id so that I can update the status column.
Let me understand better. Do you need to set status to all rows? Can you explain more about the process?
Usually lookups take some time, anyway remember to execute in Run mode (not Debug) to measure real processing time. There is a huge difference in these cases
(From i In Enumerable.Range(0,dtData.Rows.Count)
Let v = dtData.Rows(i)("StringCol").toString.Trim.ToUpper
Where v.Equals("FINDME")
Select i).DefaultIfEmpty(-1).toArray