Iterate through datatable

Question

Hi I have a table with 845 records I Need to take 100 rows each time and push them to one service. This needs to repeat till records complete in datatable. Help me on this. With REgards Datta.G

Vulpes · Answer

Suppose 'dt' is your DataTable. Then you could do something like this to partition it into 100 DataRow batches: int numRows = dt.Rows.Count; int numBatches = numRows / 100; int remainder = numRows % 100; if (remainder > 0) { ++numBatches; } else { remainder = 100; } for(int i = 0; i { int batchSize = (i DataRow[] rows = new DataRow[batchSize]; for(int j = 0; j { rows[i] = dt.Rows[100 * i + j]; } // code to push 'rows' to service }