/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 vote179 views2 answers
C# list remove by index
C#
0 vote176 views1 answer
IOS app crashing on ios 15 unity
C#Unity
0 vote181 views1 answer
System.IO.FileNotFoundException: 'Could not load file or assembly 'Microsoft.Bcl.AsyncInterfaces, Version=1.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'.
C#
1 vote254 views1 answer
How to cast list to observablecollection c#
C#
0 vote171 views1 answer
Ontriggerenter2d not working
C#
7 votes170 views4 answers
C# append to file
C#
0 vote237 views1 answer
Unity PlayOneShoot Audio
C#Unity
1 vote131 views1 answer
Create iis pool programmatically c#
C#
1 vote169 views1 answer
Difference between executescalar and executenonquery and executereader
C#
0 vote156 views1 answer
Add header in action asp.net mvc
C#