How to split Data table

[bpt.teja1996]

Hi i need a help from u people i was having data table with 9lakhs to 15lakhs row we dont know the exact number but it will be in that range now i need to split that data table in to 2 data table so that i can create excel files by pasting them as excel cant take 15lakhs i need to split that in to 2 tables can any one help me please

[Shikhar_Tandon]

Hi @bpt.teja1996 ,

Split Datatable into 4 different tables

@thomasb82 lets assume following variables: [grafik] NoOfSegments is indicating how many splits we do want have Doing an integer division to find out how many rows will be in a split (we cannot fetch a rows count with fractions e.g. 14.25 rows [grafik] with following LINQ we can produce a list of datatables with the splits: [grafik] (From i In Enumerable.Range(0,NoOfSegments) Let opart = dtData.AsEnumerable.Skip(i*FullSegmentSize).toList Let spart = If(i = (NoOfSegments - 1), opart, opa…

Check the above link if that helps you.

Cheers!!