Split a DataTable into two DataTables

[MarkusJNZ]

Hi, I have a DataTable which I want split into two other datatables
with the top 1/2 of the original datatable in one datatable and the
other 1/2 in another datatable.

Is there any easier way to do this other than iterating through the
original datatable row by row and copying the row to a new datatable??

Thanks
Markus

[Nicholas Paldino [.NET/C# MVP]]

Markus,

If you have a criteria that you could use to search through the
DataTable, you could use the Select method on the DataTable to select the
appropriate rows out, and then iterate through those, copying them over.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

<Ma*******@gmail.comwrote in message
news:11**********************@z28g2000prd.googlegr oups.com...

Hi, I have a DataTable which I want split into two other datatables
with the top 1/2 of the original datatable in one datatable and the
other 1/2 in another datatable.

Is there any easier way to do this other than iterating through the
original datatable row by row and copying the row to a new datatable??

Thanks
Markus

[MarkusJNZ]

On May 23, 10:48 pm, "Nicholas Paldino [.NET/C# MVP]"
<[e-mail]:

Markus,

If you have a criteria that you could use to search through the
DataTable, you could use the Select method on the DataTable to select the
appropriate rows out, and then iterate through those, copying them over.

--
- Nicholas Paldino [.NET/C# MVP]
- [e-mail]

<[e-mail] in message

news:11**********************@z28g2000prd.googlegr oups.com...

Hi, I have a DataTable which I want split into two other datatables
with the top 1/2 of the original datatable in one datatable and the
other 1/2 in another datatable.

Is there any easier way to do this other than iterating through the
original datatable row by row and copying the row to a new datatable??

Thanks
Markus- Hide quoted text -

- Show quoted text -

Hi, thanks for your help :)
Regards
Markus