Reader Level:
Article
Error Zone

One or more rows contain values violating non-null, unique, or foreign-key constraints

By Mahesh Chand on Mar 14 2008
You may get this error when using a typed DataSet. This tip shows how to fix it.
    • Like
    • Love It
    • Awesome
    • Interesting
    • It's Okay
    • Thumbs Down
  • 86.7k
  • 0

The following error ususally occurs when your typed DataSet is confused about a key constraints.

  • "An error has occurred during report processing.
    • Exception has been thrown by the target of an invocation.
      • Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. "

To fix this problem, try to delete your typed DataSet and create again by dragging a table or SP direct on the Form from your Database.

If it does not solve your problem, open your Typed DataSet in designer by double clicking on .xsd file and delete the key contraints from the column.

Here are some more threads on this topic:

  1. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=364416&SiteID=1
  2. http://weblogs.asp.net/rosherove/archive/2004/10/03/DataSet-hell-_2D00_-_2200_Failed-to-enable-constraints.-One-or-more-rows--contain-values_2E002E002E002E002200_.aspx
  3. http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic14842.aspx
  4. http://www.dotnet247.com/247reference/msgs/21/108864.aspx