How to split the datatable to multiple datatable

Question

0.00/5 (No votes)

See more:

.NET3.0

Hi experts,
Hi have one data table it contains 5000 records.
out of these i want to send 500 record to a web service each time in a iteration.
Now my quetion is
how to split the data table which contains 5000 records to 10 parts as 500 records?

Can any one please help me to solve this issue?

thanks in advance
(Keerthi Kumar)

Posted 22-Jan-14 21:58pm

Keerthi Kumar(Andar)

Add a Solution

3 solutions

Solution 1

You can have a loop to go through your datatable and select no of data rows you need or you can select from DataTable to get data rows.

Posted 22-Jan-14 22:25pm

tarzanbappa

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RhishikeshLathe · Accepted Answer · 2014-01-22T22:27:00

Solution 2

Refer following code,

DataTable myDatatable = new DataTable();//Original datatable
           int iCount = 2;//count for each chunk
           int iIndex = 0;
           while ( iIndex < myDatatable.Rows.Count)
           {
               DataTable dtChunk = myDatatable.AsEnumerable().Skip(iIndex).Take(iCount).CopyToDataTable();
               iIndex = iIndex + iCount;
           }

Posted 22-Jan-14 22:27pm

RhishikeshLathe

Comments

Keerthi Kumar(Andar) 24-Jan-14 1:39am

thanks a lot RhishikeshLathe..

RhishikeshLathe 24-Jan-14 1:44am

Thank you for accepting solution.
Happy weekEnd.

Karthik_Mahalingam · Accepted Answer · 2014-01-22T22:50:00

Solution 3

try this

C#

int total = dt.Rows.Count;
       int countneeded = 5000;
       int split = total / countneeded;

       for (int i = 0; i < split; i++)
       {
           var Dt5000=  dt.Rows.OfType<DataRow>().Skip(i * countneeded).Take(countneeded).ToArray();
            // this Dt5000 has 5000 rows
       }

Posted 22-Jan-14 22:50pm

Karthik_Mahalingam

Comments

Keerthi Kumar(Andar) 24-Jan-14 1:32am

thanks a lot karthik

Karthik_Mahalingam 24-Jan-14 3:25am

Welcome Keerthi Kumar(Andar) :)