表A與B是父子關系,由一個字段關聯。
表C是B的嵌套表,即表C形式上作為B的一個字段.
A.B還容易填充數據﹐C怎么填充數據呢? 又如何與B關聯且作為B的一個字段呢?下而是該DataSet的XML.
<?xml version="1.0" encoding="utf-8" ?>
<xs:schema id="dstSC" targetNamespace="http://tempuri.org/dstSC.xsd" elementFormDefault="qualified"
attributeFormDefault="qualified" xmlns="http://tempuri.org/dstSC.xsd" xmlns:mstns="http://tempuri.org/dstSC.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="dstSC" msdata:IsDataSet="true">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="SC_Head">
<xs:complexType>
<xs:sequence>
<xs:element name="SC_Code" type="xs:string" minOccurs="0" />
<xs:element name="Shipping_Mark" type="xs:string" minOccurs="0" />
<xs:element name="Date" type="xs:string" minOccurs="0" />
<xs:element name="Amount" minOccurs="0" type="xs:decimal" />
<xs:element name="Currency" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="SC_Detail">
<xs:complexType>
<xs:sequence>
<xs:element name="SC_Code" type="xs:string" minOccurs="0" />
<xs:element name="Old_Prod_Code" type="xs:string" minOccurs="0" />
<xs:element name="Product_Name" type="xs:string" minOccurs="0" />
<xs:element name="Quantity" type="xs:int" minOccurs="0" />
<xs:element name="Unit" type="xs:string" minOccurs="0" />
<xs:element name="Price" type="xs:decimal" minOccurs="0" />
<xs:element name="Amount" type="xs:decimal" minOccurs="0" />
<xs:element name="InBoxQty" type="xs:int" minOccurs="0" />
<xs:element name="BoxUnit" type="xs:string" minOccurs="0" />
<xs:element name="InCtnQty" type="xs:int" minOccurs="0" />
<xs:element name="CtnUnit" type="xs:string" minOccurs="0" />
<xs:element name="Ctns" type="xs:int" minOccurs="0" />
<xs:element name="Colors">
<xs:complexType>
<xs:sequence>
<xs:element name="Old_Prod_Code" type="xs:string" minOccurs="0" />
<xs:element name="Color_Code" type="xs:string" minOccurs="0" />
<xs:element name="Color_Eng" type="xs:string" minOccurs="0" />
<xs:element name="Color_Chi" type="xs:string" minOccurs="0" />
<xs:element name="InBoxQty" type="xs:int" minOccurs="0" />
<xs:element name="Qty" type="xs:int" minOccurs="0" />
<xs:element name="Bar_Code" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:key name="key1">
<xs:selector xpath=".//mstns:SC_Head" />
<xs:field xpath="mstns:SC_Code" />
</xs:key>
<xs:keyref name="SC_HeadSC_Detail" refer="key1">
<xs:selector xpath=".//mstns:SC_Detail" />
<xs:field xpath="mstns:SC_Code" />
</xs:keyref>
</xs:element>
</xs:schema>
表C是B的嵌套表,即表C形式上作為B的一個字段.
A.B還容易填充數據﹐C怎么填充數據呢? 又如何與B關聯且作為B的一個字段呢?下而是該DataSet的XML.
<?xml version="1.0" encoding="utf-8" ?>
<xs:schema id="dstSC" targetNamespace="http://tempuri.org/dstSC.xsd" elementFormDefault="qualified"
attributeFormDefault="qualified" xmlns="http://tempuri.org/dstSC.xsd" xmlns:mstns="http://tempuri.org/dstSC.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="dstSC" msdata:IsDataSet="true">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="SC_Head">
<xs:complexType>
<xs:sequence>
<xs:element name="SC_Code" type="xs:string" minOccurs="0" />
<xs:element name="Shipping_Mark" type="xs:string" minOccurs="0" />
<xs:element name="Date" type="xs:string" minOccurs="0" />
<xs:element name="Amount" minOccurs="0" type="xs:decimal" />
<xs:element name="Currency" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="SC_Detail">
<xs:complexType>
<xs:sequence>
<xs:element name="SC_Code" type="xs:string" minOccurs="0" />
<xs:element name="Old_Prod_Code" type="xs:string" minOccurs="0" />
<xs:element name="Product_Name" type="xs:string" minOccurs="0" />
<xs:element name="Quantity" type="xs:int" minOccurs="0" />
<xs:element name="Unit" type="xs:string" minOccurs="0" />
<xs:element name="Price" type="xs:decimal" minOccurs="0" />
<xs:element name="Amount" type="xs:decimal" minOccurs="0" />
<xs:element name="InBoxQty" type="xs:int" minOccurs="0" />
<xs:element name="BoxUnit" type="xs:string" minOccurs="0" />
<xs:element name="InCtnQty" type="xs:int" minOccurs="0" />
<xs:element name="CtnUnit" type="xs:string" minOccurs="0" />
<xs:element name="Ctns" type="xs:int" minOccurs="0" />
<xs:element name="Colors">
<xs:complexType>
<xs:sequence>
<xs:element name="Old_Prod_Code" type="xs:string" minOccurs="0" />
<xs:element name="Color_Code" type="xs:string" minOccurs="0" />
<xs:element name="Color_Eng" type="xs:string" minOccurs="0" />
<xs:element name="Color_Chi" type="xs:string" minOccurs="0" />
<xs:element name="InBoxQty" type="xs:int" minOccurs="0" />
<xs:element name="Qty" type="xs:int" minOccurs="0" />
<xs:element name="Bar_Code" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:key name="key1">
<xs:selector xpath=".//mstns:SC_Head" />
<xs:field xpath="mstns:SC_Code" />
</xs:key>
<xs:keyref name="SC_HeadSC_Detail" refer="key1">
<xs:selector xpath=".//mstns:SC_Detail" />
<xs:field xpath="mstns:SC_Code" />
</xs:keyref>
</xs:element>
</xs:schema>
大蝦們﹗要有耐心啊!兄弟我在這裡就靠你們啦!
孟子的显示主从表相當于我上面的A和B的關系.
但是B和C的關系有些特別﹐表C象是包含在B中啊!它們沒有關聯的字段