/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 vote863 views2 answers
IdentityModelEventSource.ShowPII
C#
0 vote458 views1 answer
Unity how to set framrate C#
C#Unity
0 vote355 views3 answers
C# encrypt folder SHA512
C#
0 vote406 views1 answer
Set teh screen rect of camera unity
C#Unity
1 vote359 views1 answer
Unity change particle system sorting layer via script
C#
-1 vote344 views1 answer
Instantiate date time variable C#
C#
0 vote350 views2 answers
Wpf yes no message box exit
C#
0 vote338 views1 answer
Entity framework delete record with foreign key constraint
C#
0 vote413 views1 answer
Unity Texture2D efficient performance draw pixels
C#
1 vote405 views1 answer
Unity C# make object face away
C#Unity