/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

1 vote162 views1 answer
New parameterized thread c#
C#
0 vote143 views1 answer
Real world example of sinleton design pattern
C#
31 votes206 views3 answers
Reload scene unity
C#Unity
6 votes103 views1 answer
C# ide online
C#
1 vote161 views3 answers
C# get string in parentheses
C#
40 votes196 views3 answers
Unity print to console
C#
3 votes188 views2 answers
Unity mouse click m
C#Unity
1 vote185 views1 answer
C# making a folder
C#
3 votes151 views1 answer
How to look for substring in string in c#
C#
3 votes180 views1 answer
C# center text
C#