writing xml with ado dataset

[sparty1022]

I need to write an xml file based on the results of queries to an oracle view. I am using datasets and nesting the tables. This seemed to work until I needed to nest a table within another table.

With ds.Tables("Premises")
.Columns("stateacctrecordid").ColumnMapping = MappingType.Element
.Columns("premisesdescription").ColumnMapping = MappingType.Element
.Columns("operationtype").ColumnMapping = MappingType.Element
.Columns("species").ColumnMapping = MappingType.Element
.Columns("conum").ColumnMapping = MappingType.Hidden
.Columns("active").ColumnMapping = MappingType.Hidden
End With
With ds.Tables("PremisesAddress")
.Columns("prem_id").ColumnMapping = MappingType.Hidden
.Columns("street").ColumnMapping = MappingType.Element
.Columns("city").ColumnMapping = MappingType.Element
.Columns("state").ColumnMapping = MappingType.Element
.Columns("zip").ColumnMapping = MappingType.Element
.Columns("county").ColumnMapping = MappingType.Element
.Columns("conum").ColumnMapping = MappingType.Hidden
.Columns("active").ColumnMapping = MappingType.Hidden
End With

The Premises address is supposed to nest under the premises ("stateacctrecordid"). I don't know how to get this to happen.
Is there another way I can accomplish this?

If I have an existing schema can I utilize this and re-create my oracle view?

 

[kulrom]

take a look at this thread http://www.vbdotnetforums.com/showthread.php?t=3861

Cheers