/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 vote268 views1 answer
Unity normalize movement
C#Unity
0 vote260 views1 answer
Convert from xls to xlsx C#
C#
0 vote191 views1 answer
Get first word in string c#
C#
3 votes247 views1 answer
Unity on mousewheel down
C#Unity
5 votes245 views3 answers
List search c#
C#
0 vote240 views1 answer
When creating a new boolean column in an existing table how to set the default value as true in c# models code first
C#
16 votes256 views2 answers
Get index of array element without indexof c#
C#
0 vote253 views1 answer
GetNetworkTime
C#
3 votes267 views2 answers
Unity Make a 2D object look at the mouse position
C#Unity
0 vote238 views1 answer
Join dictionaries keys c#
C#