我在C＃中生成报告时出错 [英] I have an error in report generation in C#

问题描述

我必须去桌子。一个用于销售H（销售负责人存储如billno，billdate，客户名称，总计，折扣，净总额）和其他用于销售（billno，项目名称，项目数量，

项目价格，项目总计） .salesH.billno具有billno of sales的索引键和foregin键。我正在使用C＃报表查看器创建报表。但是当我执行时，一个错误即将到来。

I have to tables. One for salesH(sales head storing like billno, billdate, customer name, gross total,discounts,net total) and other for sales(billno, item name,item qty,
item price,item total).salesH.billno is having index key and foregin key of billno of sales.I am creating a reportwith C# report viewer.but when i am executing one error is coming."

"Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints"

。我正在使用系统生成的sql查询与查询构建器创建此。我在SSMS中执行该查询。它正在显示结果。但这里只有prob。这里我的sql查询

.I am creating this with system generated sql query with query builder. I executed that query in SSMS. It is showing result. but Here only prob. Here my sql query

SELECT        sales.itemname, salesH.taxable, salesH.custname, sales.qty, sales.price, sales.tax, sales.Itemtot, sales.pertonum, salesH.nettot, salesH.discount, salesH.billtax, salesH.grosstot, salesH.billno
FROM            sales INNER JOIN
                         salesH ON sales.billno = salesH.billno
"

我的尝试：



我在SSMS中检查了数据和查询。它即将到来。具有启用约束的问题。这是什么？为什么要来。我现在必须做什么。

What I have tried:

I checked data and query in SSMS also.it is coming there.Problem with enable constraints. so what is this. why is coming. what I have to do now.

推荐答案

尝试删除外键。请关注以下链接：

Link1： asp .net - 提供无法启用约束错误的InnerJoin查询错误 - 堆栈溢出 [ ^ ]

Link2： c＃ - 无法启用约束。一行或多行包含违反非null，唯一或外键约束的值 - Stack Overflow [ ^ ]

try removing the foreign key. please follow those link:
Link1: asp.net - InnerJoin Query giving "Failed to enable constraints" error - Stack Overflow[^]
Link2: c# - Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints - Stack Overflow[^]

这篇关于我在C＃中生成报告时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！