Iterate through datatable

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 < numBatches; i++)

{

int batchSize = (i < numBatches - 1) ? 100 : remainder;

DataRow[] rows = new DataRow[batchSize];

for(int j = 0; j < batchSize; j++)

{

rows[i] = dt.Rows[100 * i + j];

}

// code to push 'rows' to service

}