The code shown below is designed to increment through each row in a database table. Correct the error in the code. For intRecordCount = 0 To datPeople.Rows.Count ' Processing statements Next
The code shown below is designed to increment through each row in a
For intRecordCount = 0 To datPeople.Rows.Count
' Processing statements
Next
We have to increment through each row in a database table, for that we can use any of the following methods.
Method 1:
We can use built-in functions when the related packages gets imported and also by a try block. In such way we can iterate through rows as per the following coding.
Coding:
TableIterator<Row> iter = dataPeople.tableIterator(key, null, null);
Try
{
while (iter.hasNext())
{
Row row = iter.next();
// info
}
}
Finally
{
if (iter != null)
{
iter.close();
}
}
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
