/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 vote247 views1 answer
System.InvalidOperationException: No owin.Environment item was found in the context.
C#
0 vote241 views1 answer
C# an object on upper level cannot be added to an object
C#
0 vote280 views1 answer
Unity normalize movement
C#Unity
0 vote248 views2 answers
Methods c#
C#
0 vote198 views1 answer
The entity type has multiple properties with the [Key] attribute.
C#
0 vote259 views1 answer
C# if statement no braces
C#
0 vote239 views1 answer
C# datagridview filter textbox
C#
0 vote258 views1 answer
Uninitialized array c#
C#
0 vote309 views1 answer
Convert word files to plain text c#
C#
0 vote245 views1 answer
C# double to string with dot
C#