VB.Net - Set value in DataTable row
Posted on 2013-01-29
Good Day Experts!
Another day where I have to utilize something in VB.Net that I have not before...hopefully you can help.
I have a DataReader that I am looping through. Each time around, I need to search for a value from it in a DataTable. If found in the DataTable, I need to update a value in the DataTable row. Here is what I have so far:
Dim row() As DataRow = tblRS.Select("[GL]='" & sqlRS2rdr.GetValue("GL") & "'")
If row(0) is Nothing Then
'Update row() "TotalPaid" field with sqlRS2rdr.GetValue("TotalPaid")
If the GL code value from the DataReader sqlRS2rdr is found in the DataTable tblRS, then update the DataTable tblRS TotalPaid field in the row with the TotalPaid value from the DataReader sqlRS2rdr.
I cannot seem to find the syntax to accomplish this.
Can you help?