reading XML with relationships

regulardude · February 14th, 2008, 04:11 PM

Hi,

I'm getting "A child row has multiple parents" error when I try to read an xml file created from a dataset that has two related tables. Both have a primary key, and are related using:

Code:

//Assign a relation   
DataRelation relation = myDS.Relations.Add(primarykey, foreignkey);
//Ask ADO.NET to generate nested XML nodes   
relation.Nested = true;

I am reading the xsd file first and then the xml file.

Any ideas?

regulardude · February 14th, 2008, 04:21 PM

I actually got it working using XmlReadMode.DiffGram.

But I have another question, I thought that because I related the tables in the dataset and then I binded them to datagrids, this would create a master/detail linked situation, i.e. when I click on a master record, the related detail record will get focus.

Do I have to code that functionality?

samjudson · February 15th, 2008, 04:57 AM

I think you need to use the BindingSource objects.

There are plenty of examples, just search for "BindingSource master detail", e.g.: http://msdn2.microsoft.com/en-us/library/y8c0cxey.aspx

/- Sam Judson : Wrox Technical Editor -/