VB.Net - DataTable Row Reference
Posted on 2013-01-17
Good Day Experts!
I have a little project that I am working on - VB6 to VB.Net conversion. The original VB6 code uses a recordset to loop through the records. Within the loop, the code checks for EOF. If EOF, then the code backs up one record to get data.
So, now I am trying to figure out how to make that happen in .Net.
1) Is there a way at the bottom of my For DataTable loop to check if the current row of
the DataTable is the last one?
2) Then, if it is the last row of the DataTable, back up a row in the DataTable so I can
reference that row data to run a Select query?
Thanks for the help,