Last post Jul 06, 2011 10:29 AM by GMann
Jul 05, 2011 05:59 PM|GMann|LINK
I am trying to do a lookup on a datatable so that I can update items on the same datarow.
I will be updating the datatable with data as I loop through a dataset using
For instance :
myDataTable = mgr_id, item1 item2
108 15 15
So the next record read from my data set loop needs to update item2 for mgr_id
Here is what i tried code wise:
Dim ToDoRows() as DataRows
ToDoRows = myDataTable.Select(mgr_id)
If (ToDoRows.Length <1) then
"No records found"
ToDoRows(2) = 10
Thanks for your help !
Jul 06, 2011 10:29 AM|GMann|LINK
I need to use the other method on my datatable - FIND().
This uses a primary key to do lookups.