How do I copy datatable from one dataset to another.

[Katit]

I get dataset from database. I need to take specific datatable out of
it and add it to second dataset to pass back from webservice.

ds.Tables.Add(dsPart.Tables[0]);

I get exception "Datatable already belongs to another dataset"
Which is true :) But why can't I do that?

TIA

[Michael Nemtsev]

Hello Katit,

use Clone() method like ds.Tables.Add(dsPart.Tables[0].Clone());

KI get dataset from database. I need to take specific datatable out of
Kit and add it to second dataset to pass back from webservice.
K>
Kds.Tables.Add(dsPart.Tables[0]);
K>
KI get exception "Datatable already belongs to another dataset" Which
Kis true :) But why can't I do that?
K>
KTIA
K>
---
WBR,
Michael Nemtsev :: blog: http://spaces.live.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[Michael Nemtsev]

Hello Katit,

use Clone() method like ds.Tables.Add(dsPart.Tables[0].Clone());

KI get dataset from database. I need to take specific datatable out of
Kit and add it to second dataset to pass back from webservice.
K>
Kds.Tables.Add(dsPart.Tables[0]);
K>
KI get exception "Datatable already belongs to another dataset" Which
Kis true :) But why can't I do that?
K>
KTIA
K>
---
WBR,
Michael Nemtsev :: blog: http://spaces.live.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[Katit]

Michael Nemtsev wrote:

Hello Katit,

use Clone() method like ds.Tables.Add(dsPart.Tables[0].Clone());

Spasib!

[Katit]

Katit wrote:

Michael Nemtsev wrote:

Hello Katit,

use Clone() method like ds.Tables.Add(dsPart.Tables[0].Clone());

Spasib!

Actually, it should be Copy(). Clone() only gets table with structure,
but no data.

[Michael Nemtsev]

Hello Katit,

yep, sorry, my error :)
it's Copy() definitely

KKatit wrote:
K>

>Michael Nemtsev wrote:

>>Hello Katit,

use Clone() method like ds.Tables.Add(dsPart.Tables[0].Clone());

Spasib!

KActually, it should be Copy(). Clone() only gets table with
Kstructure, but no data.
K>
---
WBR,
Michael Nemtsev :: blog: http://spaces.live.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche