Split a datatable into more than one datatable

Question

1.00/5 (2 votes)

See more:

Agent:

Brittan Ropchock
Brittany York
Connie Ackerman
Dorothy Kester
Jessica Oakes
Jon Fedorek
Kale Granda (Support)
Kateri Hall
Kathy Roof
Katie Drake
Leona Siliga (Support)
Leslie Keyes
Matt Silvers
Rebecca Larsen
Sandra Lewis
Sara Barnhart

Totals:

Barbara Macormac
Cassandra York
Corinda Brady
DeNeal Fox
James Moyer
Marla Stearns
Megan Amacher

Totals:

Amber Staub
Lea McGuinn
Nathan Lytle

Totals:

Jacob Balmer
Kelly O'Malley
Kristin Rakoczy
Sara Guerra
Stephanie Beatty
Stephanie Turner

Totals:

Alex Medrano
Brad Starks
Brichelle Humphrey
Byron Phillips
Chad Mitchell
Daniel McAteer
Daniel Montez
Joseph Salazar
Lawrence Evans
Lee Davis
Lottie Conway
Matt Stewart
Miguel Campos
Mirrie Mitchell
Nathan Morris
Sandra Reyes
Steven Coleman
Venessa Trevino

Nora Caro

I have a datatable like this..I want to split it like

Brittan Ropchock
Brittany York
Connie Ackerman
Dorothy Kester
Jessica Oakes
Jon Fedorek
Kale Granda (Support)
Kateri Hall
Kathy Roof
Katie Drake
Leona Siliga (Support)
Leslie Keyes
Matt Silvers
Rebecca Larsen
Sandra Lewis
Sara Barnhart

Barbara Macormac
Cassandra York
Corinda Brady
DeNeal Fox
James Moyer
Marla Stearns
Megan Amacher

I dnont want Totals: and Agents: row value.

I need it urgently.Thanks if any help will be provided

Posted 1-Jun-15 23:13pm

rajshree748

Add a Solution

Comments

Maciej Los 2-Jun-15 7:03am

Not a question at all! It's impossible to help you if you do not provide details.

1 solution

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)

Maciej Los · Accepted Answer · 2015-06-02T02:18:00

Try this:

C#

DataSet ds = new DataSet();
DataTable dt= null;
//srcDt - it's datatable object which contains above data
foreach(DataRow dr in srcDt.Rows)
{
    if(dr[0]=="Totals:" || dr[0]=="Agent:")
    {
        dt = new DataTable();
        DataColumn dc = new DataColumn("FullName", Type.GetType("System.String"));
        dt.Columns.Add(dc);
        ds.Tables.Add(dt);
    }
    else
    {
        if(dr[0].ToString().Trim()!=string.Empty)
        {
            string tmp = dr[0].ToString();
            dt.Rows.Add(new Object[]{tmp});
        }
    }
}
//completed!

Note: this is very basic sample. I do not guarantee that meet your needs.