datatable

[daveL]

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

 

[Alberto Poblacion]

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[].

 

[DaveL]

thanks alot , much appriciated
DaveL

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[].