/C#/Split a datatable based on number of rows

Split a datatable based on number of rows

DataTable[] splittedtables = tbl.AsEnumerable()
    .Select((row, index) => new { row, index })
    .GroupBy(x => x.index / 12)  // integer division, the fractional part is truncated
    .Select(g => g.Select(x => x.row).CopyToDataTable())
    .ToArray();

Source: stackoverflow.com

Split a datatable based on number of rows

 List<DataTable> result = DTHead.AsEnumerable()
            .GroupBy(row => row.Field<int>("MIVID"))
            .Select(g => g.CopyToDataTable())
            .ToList();

Source: stackoverflow.com

Similar codes

0 vote148 views2 answers
Openiddect ef core table not creating
C#
1 vote150 views1 answer
How to get the world position of the edge of an object?
C#
1 vote136 views1 answer
C# list string initialize inline
C#
0 vote141 views1 answer
Random seed in c#
C#
-1 vote140 views2 answers
Error CS1513: } expected but there is already unity
C#
0 vote150 views1 answer
Add spaces in string
C#
0 vote149 views1 answer
Find first monday of every month algorithm c#
C#
0 vote150 views1 answer
Invalidoperationexception c# ui thread
C#
3 votes149 views3 answers
C# linq list select
C#
0 vote145 views1 answer
Unity get rid of mouse
C#