This row already belongs to another Table error

Question

0.00/5 (No votes)

See more:

Hi,

What's the wrong in this code , i want to store dt1 data dt2 data is not match that information i want to store in another datatable dt3.But in the below highlighted line it shows the error this row already belongs to another table.

C#

DataTable dt3 = dt1.Clone();
foreach (DataRow dr1 in dt2.Rows)
{
    foreach (DataRow dr2 in dt1.Rows)
    {
        if (dr1.ItemArray[0].ToString() != dr2.ItemArray[0].ToString())
        {
            DataRow dr3 = dt3.NewRow();
            dr3 = dr2;
            dt3.Rows.Add(dr3);
        }
    }
}

can any one help me to resolve this issue....

Thanx in advance....

Posted 10-Oct-12 23:43pm

pranathis012

Add a Solution

5 solutions

Solution 4

You have to use ImportRow instead of Rows.Add
or
Use [datatable].Rows.Add([datarow].ItemArray);

Posted 2-Jan-13 1:53am

Spirits Soft Tech Nology , Dharmapuri

Updated 2-Jan-13 1:54am

v2

Solution 5

DataTable First;//This Data Table contains the data

Now i want to copy the row to another table, while coping i got the error message

"This row already belongs to another table."

To fix the above siuue i have used the below solution.

DataTable second= new DataTable();
second = First.Clone();
//With out clone the First table, second table wont fill the data
// even it execute the below ststement table doesn't contains the data.
dt.ImportRow(msg);

Thank you,
Ravindra

Posted 23-Apr-13 20:16pm

Member 3402334

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)

OriginalGriff · Accepted Answer · 2012-10-10T23:47:00

Solution 1

A Row can only be in one table at a time. If you want the same data in more than one table, you will have to copy the data into a new DataRow and add the new row instead.

It's just like filing a letter - the original can only be in one place: if you want it in two separate physical files, you have to use a photocopier.

Posted 10-Oct-12 23:47pm

OriginalGriff

Comments

[no name] 11-Oct-12 5:51am

in my dt1 i have ----1,2,3 values
dt2 i have ----1,2
now i want to compare 2 datatables and missmatched values to store in some other datatable, how to do this

[no name] 11-Oct-12 5:53am

here i'm creating new row and that row assigned to datatable what's the wrong

OriginalGriff 11-Oct-12 6:21am

DataRow dr3 = dt3.NewRow();
dr3 = dr2;
dt3.Rows.Add(dr3);
dr3 = dr2;
Copies the reference, not the content.
Think of it as a house address: if you copy the address of your parents house from one piece of paper to another, you do not copy the house itself!

[no name] 11-Oct-12 6:34am

thanks griff i got the solution dt.importrow(dr);

vasim sajad · Accepted Answer · 2012-10-11T00:04:00

use importrow

DataTable dt3 = dt1.Clone();
                    foreach (DataRow dr1 in dt2.Rows)
                    {
                        foreach (DataRow dr2 in dt1.Rows)
                        {
                            if (dr1.ItemArray[0].ToString() != dr2.ItemArray[0].ToString())
                            {
                                DataRow dr3 = dt3.NewRow();                               
                                dt3.ImportRow(dr2);                                
                            }
                        }
                    }

Toniyo Jackson · Accepted Answer · 2012-10-11T00:10:00

Solution 3

You have to use ImportRow instead of Rows.Add.

dt3.ImportRow(dr3);

Posted 11-Oct-12 0:10am

Toniyo Jackson