我的一个xsd文件(xml)包含三个记录集,我建立了三个记录之间的关系
我在启用约束的时候老报错误,不知道是哪里出现问题了。错误提示如下:System.Data.ConstraintException: 未能启用约束。一行或多行中包含违反非空、唯一或外键约束的值。请问大侠帮帮我~~~,谢谢我的xsd文件三个记录集如下
ManyDealerAccountTotal,
sp_TPL_GetManySaleOrdersForPrintTitle,
sp_TPL_GetManySaleOrdersForPrint,
这三个记录集之间的关系如下:
ManyDealerAccountTotal(dealerid)一对一GetManySaleOrdersForPrintTitle(dealerid)GetManySaleOrdersForPrint(SaleOrderNo)多对一GetManySaleOrdersForPrintTitle(SaleOrderNo)我的xsd文件如下,
<?xml version="1.0" encoding="utf-8" ?>
<xs:schema id="Dataset_ManySaleOrdersTitle" targetNamespace="http://tempuri.org/Dataset_ManySaleOrdersTitle.xsd"
elementFormDefault="qualified" attributeFormDefault="qualified" xmlns="http://tempuri.org/Dataset_ManySaleOrdersTitle.xsd"
xmlns:mstns="http://tempuri.org/Dataset_ManySaleOrdersTitle.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="Dataset_ManySaleOrdersTitle" msdata:IsDataSet="true">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="sp_TPL_GetManySaleOrdersForPrintTitle">
<xs:complexType>
<xs:sequence>
<xs:element name="SaleOrderNO" type="xs:string" />
<xs:element name="SaleTime" type="xs:dateTime" />
<xs:element name="DealerName" type="xs:string" minOccurs="0" />
<xs:element name="Address" type="xs:string" minOccurs="0" />
<xs:element name="TelePhone" msdata:ReadOnly="true" type="xs:string" minOccurs="0" />
<xs:element name="DealerID" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="sp_TPL_GetManySaleOrdersForPrint">
<xs:complexType>
<xs:sequence>
<xs:element name="SaleOrderNO" type="xs:string" />
<xs:element name="SaleTime" type="xs:dateTime" />
<xs:element name="OperatorName" type="xs:string" />
<xs:element name="RealQuantity" type="xs:int" />
<xs:element name="Price" type="xs:decimal" />
<xs:element name="SalePrice" msdata:ReadOnly="true" type="xs:decimal" minOccurs="0" />
<xs:element name="GoodsName" type="xs:string" />
<xs:element name="prequantity" type="xs:int" minOccurs="0" />
<xs:element name="realwash" type="xs:decimal" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ManyDealerAccountTotal">
<xs:complexType>
<xs:sequence>
<xs:element name="TotalReturnProfit" type="xs:int" />
<xs:element name="TotalCanUseMoney" type="xs:int" />
<xs:element name="DealerID" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Dataset_ManySaleOrdersTitleKey1">
<xs:selector xpath=".//mstns:sp_TPL_GetManySaleOrdersForPrintTitle" />
<xs:field xpath="mstns:SaleOrderNO" />
</xs:unique>
<xs:keyref name="sp_TPL_GetManySaleOrdersForPrintTitlesp_TPL_GetManySaleOrdersForPrint" refer="Dataset_ManySaleOrdersTitleKey1">
<xs:selector xpath=".//mstns:sp_TPL_GetManySaleOrdersForPrint" />
<xs:field xpath="mstns:SaleOrderNO" />
</xs:keyref>
<xs:unique name="Dataset_ManySaleOrdersTitleKey2" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:ManyDealerAccountTotal" />
<xs:field xpath="mstns:DealerID" />
</xs:unique>
<xs:keyref name="ManyDealerAccountTotalsp_TPL_GetManySaleOrdersForPrintTitle" refer="Dataset_ManySaleOrdersTitleKey2">
<xs:selector xpath=".//mstns:sp_TPL_GetManySaleOrdersForPrintTitle" />
<xs:field xpath="mstns:DealerID" />
</xs:keyref>
</xs:element>
</xs:schema>