DataSet 載入XML 資料效果

.NET 能將 XML 結構描述和資料讀入 DataSet
對於如下的XML
<?xml version="1.0" encoding="utf-8" ?>
<dsPubs>
  <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
    <xs:element name="dsPubs">
      <xs:complexType>
        <xs:sequence>
          <xs:element maxOccurs="unbounded" name="authors">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="au_id" type="xs:string" />
                <xs:element name="au_lname" type="xs:string" />
                <xs:element name="au_fname" type="xs:string" />
                <xs:element name="au_phone" type="xs:string" />
                <xs:element name="orders">
                  <xs:complexType>
                    <xs:sequence>
                      <xs:element maxOccurs="unbounded" name="order" type="xs:unsignedByte" />
                    </xs:sequence>
                  </xs:complexType>
                </xs:element>
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:sequence>
      </xs:complexType>
    </xs:element>
  </xs:schema>
<authors>
  <au_id>172-32-1176</au_id>
  <au_lname>國國</au_lname>
  <au_fname>Paul</au_fname>
  <au_phone>408 555-0123</au_phone>
  <orders>
    <order>1</order>
    <order>2</order>
    <order>3</order>
  </orders>
</authors>
 
<authors>
  <au_id>213-46-8915</au_id>
  <au_lname>Gray</au_lname>
  <au_fname>Chris</au_fname>
  <au_phone>415 555-0120</au_phone>
  <orders>
    <order>11</order>
    <order>22</order>
    <order>33</order>
  </orders>

</authors>
 
<authors>
  <au_id>id</au_id>
  <au_lname>lname</au_lname>
  <au_fname>fname</au_fname>
  <au_phone>phone</au_phone>
  <orders>
    <order>111 </order>
    <order>222 </order>

  </orders>
</authors>
</dsPubs>
載入為DATASET後則是如下表格效果

au_id	au_lname	au_fname	au_phone	authors_Id
172-32-1176	國國	Paul	408 555-0123	0
213-46-8915	Gray	Chris	415 555-0120	1
id	lname	fname	phone	2

orders_Id	authors_Id
0	0
1	1
2	2

order_Column	orders_Id
1	0
2	0
3	0
11	1
22	1
33	1
111	2
222	2