XML file to dataset with variable element names

[Markus Freitag]

Hello,
I want to import an xml file and implement a dataset.
I asked a few weeks ago and know I have to take xsd.
xsd Order.xml /c
Problem ist das Element Panel with the index 1,2,3 or more.
<count>3</count> is variable
Is variable, sometimes more, sometimes less.
How could I solve this?
I can not change the date is a Default.

Name of File Order.xml
<order>
060777777
<model>203 777-01 V05</model>
<count>3</count>
<panel1>
<index1 ref1="0001" ref2="001" ref3="6MIN8F">0607777770001</index1>
<index2 ref1="0001" ref2="001" ref3="6MIN8F">0607777770001</index2>
<index3 ref1="0001" ref2="001" ref3="6MIN8F">060777777 0001 001</index3>
<index4 ref1="0001" ref2="002" ref3="6MIN8F">060777777 0001 002</index4>
<index5 ref1="0001" ref2="003" ref3="6MIN8F">060777777 0001 003</index5>
<index6 ref1="0001" ref2="004" ref3="6MIN8F">060777777 0001 004</index6>
<index7 ref1="0001" ref2="005" ref3="6MIN8F">060777777 0001 005</index7>
<index8 ref1="0001" ref2="006" ref3="6MIN8F">060777777 0001 006</index8>
<index9 ref1="0001" ref2="007" ref3="6MIN8F">060777777 0001 007</index9>
<index10 ref1="0001" ref2="008" ref3="6MIN8F">060777777 0001 008</index10>
</panel1>
<panel2>
<index1 ref1="0002" ref2="001" ref3="6MIN8F">0607777770002</index1>
<index2 ref1="0002" ref2="001" ref3="6MIN8F">0607777770002</index2>
<index3 ref1="0002" ref2="001" ref3="6MIN8F">060777777 0002 001</index3>
<index4 ref1="0002" ref2="002" ref3="6MIN8F">060777777 0002 002</index4>
<index5 ref1="0002" ref2="003" ref3="6MIN8F">060777777 0002 003</index5>
<index6 ref1="0002" ref2="004" ref3="6MIN8F">060777777 0002 004</index6>
<index7 ref1="0002" ref2="005" ref3="6MIN8F">060777777 0002 005</index7>
<index8 ref1="0002" ref2="006" ref3="6MIN8F">060777777 0002 006</index8>
<index9 ref1="0002" ref2="007" ref3="6MIN8F">060777777 0002 007</index9>
<index10 ref1="0002" ref2="008" ref3="6MIN8F">060777777 0002 008</index10>
</panel2>
<panel3>
<index1 ref1="0003" ref2="001" ref3="6MIN8F">0607777770003</index1>
<index2 ref1="0003" ref2="001" ref3="6MIN8F">0607777770003</index2>
<index3 ref1="0003" ref2="001" ref3="6MIN8F">060777777 0003 001</index3>
<index4 ref1="0003" ref2="002" ref3="6MIN8F">060777777 0003 002</index4>
<index5 ref1="0003" ref2="003" ref3="6MIN8F">060777777 0003 003</index5>
<index6 ref1="0003" ref2="004" ref3="6MIN8F">060777777 0003 004</index6>
<index7 ref1="0003" ref2="005" ref3="6MIN8F">060777777 0003 005</index7>
<index8 ref1="0003" ref2="006" ref3="6MIN8F">060777777 0003 006</index8>
<index9 ref1="0003" ref2="007" ref3="6MIN8F">060777777 0003 007</index9>
<index10 ref1="0003" ref2="008" ref3="6MIN8F">060777777 0003 008</index10>
</panel3>
</order>


Example for 8
<order>
060777777
<model>203 777-01 V05</model>
<count>8</count>
<panel1>
..
..
<panel7>
<panel8>
Is wrong.
panel can be from 1 to 100
Index can be from 1 to 200
Is not fix.
<xs:element name="panel1" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element ref="index1" minOccurs="0" maxOccurs="unbounded" />
<xs:element ref="index2" minOccurs="0" maxOccurs="unbounded" />
<xs:element ref="index3" minOccurs="0" maxOccurs="unbounded" />
<xs:element ref="index4" minOccurs="0" maxOccurs="unbounded" />
<xs:element ref="index5" minOccurs="0" maxOccurs="unbounded" />
<xs:element ref="index6" minOccurs="0" maxOccurs="unbounded" />
<xs:element ref="index7" minOccurs="0" maxOccurs="unbounded" />
<xs:element ref="index8" minOccurs="0" maxOccurs="unbounded" />
<xs:element ref="index9" minOccurs="0" maxOccurs="unbounded" />
<xs:element ref="index10" minOccurs="0" maxOccurs="unbounded" />
</xs:sequence>
</xs:complexType>
</xs:element>

With best regards Markus

Continue reading...