Datatable into two parts

[KarthikByggari]

Please refer the below post for similar question.
You can use Skip and Take methods to get the required number of rows from data table.

To Break a Data table

You can use the following approach to break a data table. Assuming the data table contains 10 rows. count = 10 halfCount = count/2 = 5 newdt1= myDataTable.AsEnumerable().Skip(0).Take(halfCount).CopyToDataTable newdt2= myDataTable.AsEnumerable().Skip(halfCount).Take(halfCount).CopyToDataTable newdt1 contains first 5 rows newdt2 contains last 5 rows Skip - Will skip the given number of rows Take - Will take the next given number of rows Regards, Karthik Byggari

Regards,
Karthik Byggari