C# copy set of rows to new datatable in loop with conditions

Question

0.00/5 (No votes)

See more:

i am new to C#, here i am trying to copy set of rows first to new data table and do some work and copy the second set and do some work.

the entire table looks like this.

Tables	Concept1	Concept2
Name1	Th1	        AA1
	    Th2	        AA2
	    Th3	        AA3
	    Th4	        AA4
Name2	Tl1	        BB1
	    Tl2	        BB2
	    Tl3	        BB3
	    Tl4	        BB4
	    Tl5	        BB5

Here Tables, Concept1 and Concept2 are the headers.
so i have to copy the Name1 and its values first and do some work and next Name2 and its values and do some work. (Name1 and Name2 are not static it may vary)

What I have tried:

i am able to copy entire table to new table, but dont know how to start this :(.
Please help.

Posted 24-Oct-18 3:56am

Member 13476575

Updated 27-Oct-18 2:25am

v2

Add a Solution

Comments

Alek Massey 24-Oct-18 10:31am

Can you show the code you have tried?

BillWoodruff 24-Oct-18 12:51pm

"i am able to copy entire table to new table, but dont know how to start this"

What exactly does "this" mean, here ? Describe the transformation, or re-ordering, you wish to perform: then we can help you

2 solutions

Solution 2

C#

datatable2 = datatable1.Copy();

it will copy all data of datatable1.

Posted 27-Oct-18 2:26am

Kanan Gandhi

Updated 27-Oct-18 2:27am

v2

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)

Ahmad Sakr · Accepted Answer · 2018-10-26T22:53:00

Hello
If you mean this data is in datatable so try this

    List<string> iListOfTables = new List<string>();

foreach (DataRow DRow in ExistingTable.Rows) {
    if (!iListOfTables.Contains(DRow("TABLES"))) {
        iListOfTables.Add(DRow("TABLES"));
    }
    
}
    DataTable NewTable = new DataTable();
    foreach (string iTable in iListOfTables)
    {
        DataRow[] iRows = ExistingTable.Select("TABLES = '" + iTable + "'");
        NewTable.Rows.Add(iRows);
    }