Datatable split by row

Different data in the same database table must be bound to different repeater, which can be accessed multiple times, but the efficiency will be very low.

I want to first put the entire database table into the able (the table is not very large, otherwise the memory pressure will be great), and then perform operations in the memory.

Datatable dt = sourcedt. Clone (); // create a DT, source datatable structure based on the source datatable
Foreach (datarow DR in sourcedt. Rows)
{
If (condition to be split)
{
Datarow newdr = DT. newrow ();
Newdr. itemarray = dr. itemarray;
// Datarow is a reference type and cannot be directly assigned to DT. You can only copy the values in the row one by one.
DT. Rows. Add (newdr );
}
}