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

Set the Nested property of the DataRelations to False.

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


"gerry" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>
>

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


"Sahil Malik" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Set the Nested property of the DataRelations to False.
>
> - Sahil Malik [MVP]
> ADO.NET 2.0 book -
> http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
>
>
> "gerry" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > 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
> >
> >
>
>