C# Constaint error when running report

Question

0.00/5 (No votes)

See more:

Hey,

My report troughs out an constraint error as soon as i have more then one payment of the same customer in my payment table.

This is the line that the error points to:

C#

this.WaybillsTableAdapter.Fill(this.DataSet1.Waybills,textBox1.Text, textBox3.Text,textBox4.Text );

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

How do i fix this.

Can i just switch off constraints is so how do i do this

Posted 23-Sep-12 22:43pm

GoggatjieLiesl

Updated 28-Sep-12 9:47am

Maciej Los

v3

Add a Solution

Comments

OriginalGriff 24-Sep-12 4:44am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Use the "Improve question" widget to edit your question and provide better information.

GoggatjieLiesl 24-Sep-12 5:07am

Thanks hope the question update helps

Sergey Alexandrovich Kryukov 24-Sep-12 13:39pm

What is "constaint"?
--SA

ZurdoDev 28-Sep-12 16:24pm

It sounds like your foreign key is blocking it. You'll have to fix that.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2012-09-28T10:42:00

There are few reasons of it, majorly related to typed dataset that needs a refresh.

Here have a look at these to troubleshoot and resolve it:
One or more rows contain values violating non-null, unique, or foreign-key constraints[^]
ERROR : Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints [^]
How to: Troubleshoot “Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.”[^]

C# Constaint error when running report

1 solution

Solution 1

Add your solution here

Preview 0

C# Constaint error when running report

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us