/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

2 votes132 views1 answer
C++ in C#
C#
0 vote139 views1 answer
Creating a class in c#
C#
11 votes129 views1 answer
C# list to string comma separated
C#
2 votes125 views2 answers
C# get wifi ip address
C#
0 vote140 views1 answer
How to pick a random item in c#
C#
18 votes122 views4 answers
C# bytes to string
C#
0 vote169 views1 answer
C# call by reference
C#
3 votes169 views1 answer
Difference two list c#
C#
1 vote156 views2 answers
Unity sort a list
C#Unity
0 vote182 views1 answer
Csharp attributes as generics constraints
C#