我的一个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>
我在启用约束的时候老报错误,不知道是哪里出现问题了。错误提示如下: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>
解决方案 »
- 用过Cypress CyUSB.dll的各位老师请进!!
- DATASET中出现乱码
- VS2008 C# 调试程序 内存分配访问无效。 (异常来自 HRESULT:0x800703E6)
- winform记住用户名
- [20]如何遍历主窗口已经打开的所有子窗口
- 急!!!!!!谢谢!怎么在dataGrid谋一列中加入dateTimePicker,使它可以像comBox那样在dataGrid中显示和选择!!
- 如何获得本机机器在网络中的ip
- WPF程序启动新进程但是任务栏有两个图标
- C#如何将dgv插入到word?
- 请问运算符和字符串间的转换
- 请教高手:如何在.net里探测socket是否有数据可读
- 关于XOR拷贝屏幕的问题!!
查询的时候需要他们之间的关系。
ManyDealerAccountTotal表(dealerid)是唯一GetManySaleOrdersForPrintTitle表(dealerid、SaleOrderNo)是唯一的GetManySaleOrdersForPrint表(SaleOrderNo)有多条数据记录