hello,
i have seen multiple postings on the subject but no answer that
addresses my question:
I create a dataset using a xsd schema. the schema specifies a relation
from one of the tables to the other table via a primary-secondary key
on the tables.
i load the data into the dataset.
i show the data in a datagrid and i see that the relation worked
because the data of the second table is attached to the data of the
first table.
when i then write out the xml with a:
m_DynamicDatase t.WriteXml("c:\ \tomstest1.xml" ,XmlWriteMode.W riteSchema);
i first see all the entries for the first table like :
<T_APP>
<ID_APP>2003061 7190066793418</ID_APP>
<CD_TYP_APP>TER MC</CD_TYP_APP>
<AM_APP>111</AM_APP>
</T_APP>
<T_APP>
<ID_APP>2003061 7220066793204</ID_APP>
<CD_TYP_APP>TER MC</CD_TYP_APP>
<AM_APP>111</AM_APP>
</T_APP>
..... etc..
and then all the data from the second table
<T_PARTY>
<ID_APP>2003061 7190066793418</ID_APP>
<ID_PARTY>6</ID_PARTY>
<CD_ROLE_PARTY> OTHER</CD_ROLE_PARTY>
<CD_TYP_PARTY>O THER</CD_TYP_PARTY>
</T_PARTY>
<T_PARTY>
<ID_APP>2003061 7220066793204</ID_APP>
<ID_PARTY>1</ID_PARTY>
<CD_ROLE_PARTY> PrimeBrwer</CD_ROLE_PARTY>
<CD_TYP_PARTY>A PLCNT</CD_TYP_PARTY>
</T_PARTY>
is there a way that i can specify that the T_PARTY xml-sections need
to be 'under' the T_APP sections ?
do i need to change my schema for that ? or do i need to do this
programatically ?
-------------- schema follows ----------------
<?xml version="1.0" encoding="utf-8" ?>
<xs:schema id="Dataset1"
targetNamespace ="http://tempuri.org/Dataset1.xsd"
elementFormDefa ult="qualified" attributeFormDe fault="qualifie d"
xmlns="http://tempuri.org/Dataset1.xsd"
xmlns:mstns="ht tp://tempuri.org/Dataset1.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="Dataset1" msdata:IsDataSe t="true">
<xs:complexType >
<xs:choice maxOccurs="unbo unded">
<xs:element name="T_APP">
<xs:complexType >
<xs:sequence>
<xs:element name="ID_APP" type="xs:string " />
<xs:element name="CD_TYP_AP P" type="xs:string " />
<xs:element name="AM_APP" type="xs:decima l" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="T_PARTY">
<xs:complexType >
<xs:sequence>
<xs:element name="ID_APP" type="xs:string " />
<xs:element name="ID_PARTY" type="xs:string " />
<xs:element name="CD_ROLE_P ARTY" type="xs:string " />
<xs:element name="CD_TYP_PA RTY" type="xs:string " />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Dataset1K ey1" msdata:PrimaryK ey="true">
<xs:selector xpath=".//mstns:T_APP" />
<xs:field xpath="mstns:ID _APP" />
</xs:unique>
<xs:unique name="Dataset1K ey2" msdata:PrimaryK ey="true">
<xs:selector xpath=".//mstns:T_PARTY" />
<xs:field xpath="mstns:ID _APP" />
<xs:field xpath="mstns:ID _PARTY" />
</xs:unique>
<xs:keyref name="T_APPT_PA RTY" refer="Dataset1 Key1"
msdata:IsNested ="true">
<xs:selector xpath=".//mstns:T_PARTY" />
<xs:field xpath="mstns:ID _APP" />
</xs:keyref>
</xs:element>
</xs:schema>
------------ end schema -----------------------
