dataset to 'flat' xml

[gerry]

Hi ,
I have a dataset that was populated via ReadXml where the source xml
contains nested tables.
When I write the dataset back out with WriteXml I get the same hierarchical
( nested ) document structure as was present in the source document ( as
expected ).
I have a situation where I need the destination Xml document to be
'flattened' ie. no nested tables.
I thought I had done this in the past but I can't find any reference to this
Dataset capability.
Am I overlooking something or is this just not possible ?

using .NET v1.1 VS 2003

Gerry

 

[Sahil Malik]

Set the Nested property of the DataRelations to False.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx

 

[gerry]

Thanks Sahil,
I just tried this using a foreach to process the DataSet.Relations
collection but every attempt to set Nested=false results in an exception :
"Cannot set 'Nested' property to false for this relation"
I assume that this is somehow related to the tables being nested in the
loaded schema ?

Gerry