copy dataset row

[suzy]

hi im trying to copy a row from one dataset table to another dataset table.

i tried the following but it says the row belongs to another table. any
idea what im doing wrong, or if its possible?

//both datasets have been initiablised earlier

DataRow oNewRow = oDataSet.Tables["Orders"].Rows[0];

oDataSet2.Tables["Order"].Rows.Add (oNewRow);

[Eliyahu Goldin]

This is a known issue. Your oNewRow is just a reference to a row that indeed
belongs to another table. Noone took it out of there.

Try this:

oDataSet2.Tables["Order"].Rows.Add
(oDataSet.Tables["Orders"].Rows[0].ItemArray);

HTH,

Eliyahu

"suzy" <ph******@nospamming.com> wrote in message
news:OV**************@TK2MSFTNGP12.phx.gbl...

hi im trying to copy a row from one dataset table to another dataset table.
i tried the following but it says the row belongs to another table. any
idea what im doing wrong, or if its possible?

//both datasets have been initiablised earlier

DataRow oNewRow = oDataSet.Tables["Orders"].Rows[0];

oDataSet2.Tables["Order"].Rows.Add (oNewRow);

[suzy]

hi,

thanks for that. it seems to be working!
"Eliyahu Goldin" <re*************@monarchmed.com> wrote in message
news:Oh*************@tk2msftngp13.phx.gbl...

This is a known issue. Your oNewRow is just a reference to a row that indeed belongs to another table. Noone took it out of there.

Try this:

oDataSet2.Tables["Order"].Rows.Add
(oDataSet.Tables["Orders"].Rows[0].ItemArray);

HTH,

Eliyahu

"suzy" <ph******@nospamming.com> wrote in message
news:OV**************@TK2MSFTNGP12.phx.gbl...

hi im trying to copy a row from one dataset table to another dataset

table.

i tried the following but it says the row belongs to another table. any
idea what im doing wrong, or if its possible?

//both datasets have been initiablised earlier

DataRow oNewRow = oDataSet.Tables["Orders"].Rows[0];

oDataSet2.Tables["Order"].Rows.Add (oNewRow);