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"
.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
"
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.