Can you do this?

[Justin Lazanowski]

I have a dataset that I want to write to XML

The dataset has two data tables with a parent child relationship 1:1

What I want to do is when I use myDataset.WriteXML(somefile);

Create a document that places the child within the parent node for example

<TestedBatch>
<BatchNumber 1234 />
<TestDate 1/1/2006 />
<TestDetails> <--- this is the child table
<test1 "5.0">
<test2 "3.3">
</TestDetails>
</TestedBatch>

I'm not getting this when I write to XML, I get all of the parent table
entries, and then all of the child table entries.

Any thoughts?

Thanks,
Jusitn

[RJ]

XSLT may be the "standard" technique for transforming the format of an XML
document into some other format. This would be a little different concept,
where you take the output of the DS.WriteXML and apply or transform it into
a second output as specified by another XSL document. Google on ".net xsl
transform" and you should get plenty of examples.

"Justin Lazanowski" <ju****@nospam.southeastmilk.org> wrote in message
news:OV**************@TK2MSFTNGP04.phx.gbl...

I have a dataset that I want to write to XML

The dataset has two data tables with a parent child relationship 1:1

What I want to do is when I use myDataset.WriteXML(somefile);

Create a document that places the child within the parent node for example

<TestedBatch>
<BatchNumber 1234 />
<TestDate 1/1/2006 />
<TestDetails> <--- this is the child table
<test1 "5.0">
<test2 "3.3">
</TestDetails>
</TestedBatch>

I'm not getting this when I write to XML, I get all of the parent table
entries, and then all of the child table entries.

Any thoughts?

Thanks,
Jusitn