hello
i have a Datatable i use for a datagridview
when a user selects a row, i return the row to the
calling window (doubleclickevent)

in the calling method i want to set the datarow to a tmp datatable to use
with sqldataadapter updates, inserts
but when i try to add the row to the tmp table
derived from the same physical table in sql schema

i get a error row already belongs to a datatable
is there a way to change the owning table in the datarow
or do i have to create a new datarow from the tmp table
and copy the columns from the Returnd DataRow

Thanks
DaveL

"daveL" <(E-Mail Removed)> wrote in message
news:5UnIk.4700$(E-Mail Removed)...
> i get a error row already belongs to a datatable
> is there a way to change the owning table in the datarow
> or do i have to create a new datarow from the tmp table
> and copy the columns from the Returnd DataRow

Yes, that's what you have to do, but there is an easy way to do it in a
single line:

theTmpTable.Rows.Add(theDataRow.ItemArray);

"ItemArray" extracts an array of objects with the values of the columns.
That array is then used as an argument for the overload of the Add method
that takes an object[].

thanks alot , much appriciated
DaveL

"Alberto Poblacion" <earthling-(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
> "daveL" <(E-Mail Removed)> wrote in message
> news:5UnIk.4700$(E-Mail Removed)...
>> i get a error row already belongs to a datatable
>> is there a way to change the owning table in the datarow
>> or do i have to create a new datarow from the tmp table
>> and copy the columns from the Returnd DataRow
>
> Yes, that's what you have to do, but there is an easy way to do it in a
> single line:
>
> theTmpTable.Rows.Add(theDataRow.ItemArray);
>
> "ItemArray" extracts an array of objects with the values of the columns.
> That array is then used as an argument for the overload of the Add method
> that takes an object[].
>