/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 vote188 views1 answer
Mvc input number rounding
C#
1 vote204 views1 answer
C# Console multi language
C#
1 vote191 views1 answer
How to make error sound c#
C#
1 vote194 views1 answer
C# get array subarray
C#
28 votes219 views3 answers
Delay in unity
C#Unity
0 vote216 views1 answer
Blocked script execution in '<url>' because the document's frame is sandboxed and the 'allow-scripts' permission is not set.
C#
1 vote196 views1 answer
Oculus Unity add haptics
C#
13 votes242 views2 answers
C# ip address translate localhost
C#
0 vote195 views1 answer
Find qual values in a dictionary c#
C#
0 vote212 views1 answer
Get quaternion from vector unity
C#