Dim rows as DataRowCollection = oDataProvider.oDataSet.Tables("Temp").Rows >For lnCounter2 = lnStart To lnMax - 1 > loRow = rows(lnCounter2)Come to that why not allow a flexible batch size.Something like:
Public Sub ProcessAll(ByVal lnBatchSize As Integer) > Dim i As Integer = 0 > Dim lnCount As Integer = oDataSet.Tables("Temp").Rows.Count > While i < lnCount - lnBatchSize > ProcessBatch(i, i + lnBatchSize - 1) > i += lnBatchSize > End While > ProcessBatch(i, lnCount) > End Sub > Public Sub ProcessBatch(ByVal first As Integer, ByVal last As Integer) > Dim loRow As DataRow > Dim rows As DataRowCollection = oDataSet.Tables("Temp").Rows > For lnCounter2 As Integer = first To last > loRow = rows(lnCounter2) > Next > End SubFor its use so far, it was not an impact. But, doing it on a large scale dataset, then, the idea sounds good. I will have to check it out. Thanks for the info.