Relationship creation using DataSet Schema and XML Output

[Joey Lee]

Hi,

I have created a dataset schema(*.xsd) which contain two element
"InvoiceHea der" and "InvoiceDetail" .

I set the primary key of both the element. for example "InvoiceHea der" -> id
and "InvoiceDet ail" -> "id, date"

Then I created a relationship between both these item using the key "id".
This create the one-to-many relationship.

I set the relationship object for "IsNested" to true.

Now I fill up both the "InvoiceHea der" and "InvoiceDet ail" from the database

When I execute the command WriteXML(). The output xml does not have the
correct nested relationship that i defined in the dataset schema. I need to
insert the following code to ensure the output is correct

--------------------------------------------------------------------

DataRelation paRel = xmlOut.Relation s.Add("paRel",n ew DataColumn[] {
xmlOut.InvoiceH eader.Columns["id"] }, new DataColumn[] {
xmlOut.InvoiceD etail.Columns["id"] });
paRel.Nested = true;

---------------------------------------------------------------------

So based on this i am assuming that the relationship created in the dataset
schema is not working or used?. How do i enable it to do the correct nesting
and relationship without the above code?. Thanks

Joey