By chance, are you using typed datasets or untyped datasets? This error can occur if you use typed datasets and then modify the select statement to only include some of the columns.
>All,
>
> I getting the message below when trying to fill a dataset. I am stumped, please help.
>
>"Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints"
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi