datatable

  • Thread starter Thread starter daveL
  • Start date Start date
D

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
 
daveL said:
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
Click to expand...

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 said:
daveL said:
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
Click to expand...

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[].
Click to expand...
 
Back
Top