The simplest way would be to write a loop that iterated over the DataTable and allocate rows accordingly. When you do this, you need to clone the table structure, and use ImportRow to copy the row from one table to another. If you attempt to copy the row over directly, you'll get a "row belongs to another table" error. The following method does what you want:
private List<DataTable> CloneTable(DataTable tableToClone, int countLimit)<br />{<br /> List<DataTable> tables = new List<DataTable>();<br /> int count = 0;<br /> DataTable copyTable = null;<br /> foreach (DataRow dr in tableToClone.Rows)<br /> {<br /> if ((count++ % countLimit) == 0)<br /> {<br /> copyTable = new DataTable();<br />