How can I read multiple instances of a single element within a complex type?

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman; font-size:x-small I am using a C# Dataset to read an xml document defined by a xsd data schema.<span style="
I have no control over the data structure.<span style=" I cannot read multiple instances of a single element within a complex type.<span style="
Only the first instance appears in a single child node. I have looked at help from
http://support.microsoft.com/kb/311566 <span style="font-family:Times New Roman; font-size:x-small http://support.microsoft.com/kb/311566 <span style="font-family:Times New Roman; font-size:x-small and
http://www.java2s.com/Tutorial/CSharp/0540__XML/LoadXMLtoDataSet.htm <span style="font-family:Times New Roman; font-size:x-small http://www.java2s.com/Tutorial/CSharp/0540__XML/LoadXMLtoDataSet.htm <span style="font-family:Times New Roman; font-size:x-small
<span style=" <span style=" Here is part of the xsd:
<p style="margin:0cm 0cm 0pt <span style="font-size:x-small <span style="font-family:"Courier New"; color:blue <span style="
<<span style="font-family:"Courier New"; color:#a31515 xsd:element<span style="font-family:"Courier New"; color:blue
<span style="font-family:"Courier New"; color:red name<span style="font-family:"Courier New"; color:blue =<span style="font-family:"Courier New" "<span style="color:blue CollectionItems"<span style="color:blue >
<p style="margin:0cm 0cm 0pt <span style="font-size:x-small <span style="font-family:"Courier New"; color:blue <span style="
<<span style="font-family:"Courier New"; color:#a31515 xsd:complexType<span style="font-family:"Courier New"; color:blue >
<p style="margin:0cm 0cm 0pt <span style="font-size:x-small <span style="font-family:"Courier New"; color:blue <span style="
<<span style="font-family:"Courier New"; color:#a31515 xsd:sequence<span style="font-family:"Courier New"; color:blue >
<p style="margin:0cm 0cm 0pt <span style="font-size:x-small <span style="font-family:"Courier New"; color:blue <span style="
<<span style="font-family:"Courier New"; color:#a31515 xsd:element<span style="font-family:"Courier New"; color:blue
<span style="font-family:"Courier New"; color:red name<span style="font-family:"Courier New"; color:blue =<span style="font-family:"Courier New" "<span style="color:blue CollectionItem"<span style="color:blue
<span style="color:red minOccurs<span style="color:blue ="<span style="color:blue 0"<span style="color:blue
<span style="color:red maxOccurs<span style="color:blue ="<span style="color:blue unbounded"<span style="color:blue >
<p style="margin:0cm 0cm 0pt <span style="font-size:x-small <span style="font-family:"Courier New"; color:blue <span style="
<<span style="font-family:"Courier New"; color:#a31515 xsd:complexType<span style="font-family:"Courier New"; color:blue >
<p style="margin:0cm 0cm 0pt <span style="font-size:x-small <span style="font-family:"Courier New"; color:blue <span style="
<<span style="font-family:"Courier New"; color:#a31515 xsd:sequence<span style="font-family:"Courier New"; color:blue >
<p style="margin:0cm 0cm 0pt <span style="font-size:x-small <span style="font-family:"Courier New"; color:blue <span style="
<<span style="font-family:"Courier New"; color:#a31515 xsd:element<span style="font-family:"Courier New"; color:blue
<span style="font-family:"Courier New"; color:red name<span style="font-family:"Courier New"; color:blue =<span style="font-family:"Courier New" "<span style="color:blue MainSoleDescriptorCode"<span style="color:blue
<span style="color:red minOccurs<span style="color:blue ="<span style="color:blue 0"<span style="color:blue
<span style="color:red maxOccurs<span style="color:blue ="<span style="color:blue unbounded"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue nfrc:REQString"<span style="color:blue />
<p style="margin:0cm 0cm 0pt <span style="font-size:x-small <span style="font-family:"Courier New"; color:blue <span style="
<<span style="font-family:"Courier New"; color:#a31515 xsd:element<span style="font-family:"Courier New"; color:blue
<span style="font-family:"Courier New"; color:red name<span style="font-family:"Courier New"; color:blue =<span style="font-family:"Courier New" "<span style="color:blue HeelInstepDescriptorCode"<span style="color:blue
<span style="color:red minOccurs<span style="color:blue ="<span style="color:blue 0"<span style="color:blue
<span style="color:red maxOccurs<span style="color:blue ="<span style="color:blue unbounded"<span style="color:blue
<span style="color:red type<span style="color:blue ="<span style="color:blue nfrc:REQString"<span style="color:blue />
<p style="margin:0cm 0cm 0pt <span style="font-size:x-small <span style="font-family:"Courier New"; color:blue <span style="
</<span style="font-family:"Courier New"; color:#a31515 xsd:sequence<span style="font-family:"Courier New"; color:blue >
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New"; color:blue <span style="font-size:x-small
<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman; font-size:x-small
<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman; font-size:x-small And part of a typical xml:
<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman; font-size:x-small
<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman <span style="font-size:x-small - <CollectionItem internalCode="72057594037931729" modelCode="631" itemType="TRAINER" manufacturerName="ADIDAS" >
<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman <span style="font-size:x-small <span style="
<MainSoleDescriptorCode>D07</MainSoleDescriptorCode>
<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman <span style="font-size:x-small <span style="
<MainSoleDescriptorCode>D10</MainSoleDescriptorCode>
<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman <span style="font-size:x-small <span style="
<MainSoleDescriptorCode>D11</MainSoleDescriptorCode>
<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman <span style="font-size:x-small <span style="
<HeelInstepDescriptorCode>D07</HeelInstepDescriptorCode>

<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman <span style="font-size:x-small <span style="
<HeelInstepDescriptorCode>D10</HeelInstepDescriptorCode>

<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman <span style="font-size:x-small <span style="
<HeelInstepDescriptorCode>D11</HeelInstepDescriptorCode>

<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman <span style="font-size:x-small <span style="
</CollectionItem>
<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman; font-size:x-small As you can see in this example there are 3
<span style=" <MainSoleDescriptorCode> and 3 <span style="
<HeelInstepDescriptorCode>.<span style="
I use an xmlDataDocument and Dataset to read the data as follows:
<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman; font-size:x-small
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="

<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style="color:#2b91af XmlDataDocument doc = <span style="color:blue
new <span style="color:#2b91af XmlDataDocument(xmlDataSet);
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style="color:blue foreach (<span style="color:#2b91af DataRow row
<span style="color:blue in xmlDataSet.Tables[<span style="color:#a31515 "CollectionItem"].Rows)
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
{
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
item.Type = (<span style="color:blue string)row[<span style="color:#a31515 "itemType"];
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
item.Make = (<span style="color:blue string)row[<span style="color:#a31515 "manufacturerName"];
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style="color:#2b91af XmlNode node = doc.GetElementFromRow(row);
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style="color:blue foreach (<span style="color:#2b91af XmlNode childNode
<span style="color:blue in node.ChildNodes)
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
{
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style="color:blue switch (childNode.Name)
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
{
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style="color:blue case <span style="color:#a31515 "blahâ":
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style=" <span style="color:green
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style="color:blue break;
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style="color:blue case <span style="color:#a31515 "MainSoleDescriptorCode":
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style="color:blue if (childNode.HasChildNodes)
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
{
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style="color:blue foreach (<span style="color:#2b91af XmlNode dNode
<span style="color:blue in childNode.ChildNodes)
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
{
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
p.Pattern = dNode.InnerText;
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style="color:#2b91af Console.WriteLine(<span style="color:#a31515 "Sole descriptor: " + p.Pattern);
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
}
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
}
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style="color:blue break;
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style="color:blue case <span style="color:#a31515 "HeelInstepDescriptorCode":
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
// some similar code here
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
<span style="color:blue break;
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
}
<p style="margin:0cm 0cm 0pt <span style="font-family:"Courier New" <span style="font-size:x-small <span style="
}<span style="
<p style="margin:0cm 0cm 0pt <span style="font-family:Times New Roman; font-size:x-small There is only ever one single child node.<span style="
I have tried all sorts of other ways of attempting to read more than one but have failed.<span style="
How can I read all 3 of the descriptor codes?
<p style="margin:0cm 0cm 0pt <span style="font-size:x-small <span style="font-family:Times New Roman My thanks to anyone who can tell me the answer
<span style="font-family:Wingdings <span style=" J<span style="font-family:Times New Roman - Chris <hr class="sig Chris Tagg

View the full article
 
Back
Top