Read many of the posting but still doen't understand the process.
I have a dataset with child records.
I have a specific XML "Account.XSD" format that I need to write this out to.
How do I marry these (2) items to create the output file.
Dim dataSet As DataSet = New DataSet("AccountRecord")
PremisesAdapter.Fill(dataSet, "Premises")
SupAdapter.Fill(dataSet, "Supplemental")
cn.Close()
Dim AccountRecord As DataRelation =
dataSet.Relations.Add("Prem_Species", _
dataSet.Tables("Premises").Columns("ID"),
dataSet.Tables("Supplemental").Columns("Prem_ID"), False)
AccountRecord.Nested = True
Dim strPathtoXML As String = "C:\My Documents\AISS.XML"
dataSet.WriteXml(strPathtoXML, XmlWriteMode.WriteSchema)
This poroduces a file where the child records come at the end of each record
and I need to write out the child records to the middle of the Account.XSD.
How do I do that?