Failed to Enable Contraints

[Guest]

When attempting to fill a dataset using SQLDataAdapter I get the following
error message.

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

The stored procedure used here can be successfully ran in Query Analyzer. I
don't see any duplicate PK's in the records.
What could be causing this? Thanks.

 

[Sahil Malik]

One of the constraints specified in your datatable or dataset (whichever you
are filling) has a constraint that the being filled data does not satisfy.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

 

[Miha Markic [MVP C#]]

Hi,

Loop through all rows and check their RowError property.

 

[Guest]

Thanks...Found the error

Hi,

Loop through all rows and check their RowError property.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

When attempting to fill a dataset using SQLDataAdapter I get the following
error message.

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

The stored procedure used here can be successfully ran in Query Analyzer.
I
don't see any duplicate PK's in the records.
What could be causing this? Thanks.