/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

24 votes325 views1 answer
Csharp datetime string format
C#
0 vote372 views1 answer
Intro keycode unity
C#
0 vote308 views1 answer
Unity respawn c#
C#
2 votes395 views1 answer
How to remove space between string in c#
C#
11 votes340 views2 answers
Unity change tmp text from script
C#
4 votes316 views3 answers
Regular expression for email in c#
C#
0 vote378 views1 answer
Unity c# store gameobject in array
C#Unity
8 votes352 views4 answers
How to add arrays in C#
C#
0 vote314 views1 answer
How to change samesite=lax to samesite=none in asp.net
C#
2 votes330 views2 answers
The value '1990-10-23' is not valid for DOB. Data Annotation C#
C#