Typed dataset insert error

[Mike]

Hello,

I'm getting the following error:

"This row already belongs to another table. "

For this code:

while(myEnumerator.MoveNext())
{
myDS.myTable.Rows.Add((myDS.myTableRow) myEnumerator.Value);
}

This is a typed dataset, for which there is only one table, and the row
count is zero when I attempt to insert the row. So there can be no duplicate
table, since there's only one, and no duplicate record since there are no
rows.

Any idea why would I get the error?

Thanks.

 

[Sahil Malik]

Instead of "Add", use Import.

Or,

Explicitly detach the row from table #1 before adding it to table #2.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

 

[Mike]

There's only one table. There is no table #2, which is why I'm confused by
this error.

If there's only one table in my dataset, what could this error mean?

 

[Sahil Malik]

Even then you could get this error - the fact that a row is attached to a
table is remembered inside the row object. So if you try and add an already
added row - even if it is to the same table - it'll give you this error.


- Sahil Malik
http://codebetter.com/blogs/sahil.malik/