{ Duane.Wingett } - Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Tuesday, June 08, 2010

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

Today I hit hit this error message while filling a typed DataSet Datatable. The odd thing was I could preview the data in the DataSet designer and the data looked fine.

I had to resort to Google and that returned this page, which if you hit this error, I would definately recommend. Look specifically for Sanjeys post about six posts down.

Roy Osherove's Blog - Dataset Hell

Tuesday, June 08, 2010 6:35:03 PM (GMT Standard Time, UTC+00:00)

Comments [0] -
.Net | Asp.Net | C# | Database | Errors

All comments require the approval of the site owner before being displayed.

Name
E-mail	(will show your gravatar icon)
Home page

	Remember Me
Comment (Some html is allowed: `a@href@title, b, blockquote@cite, em, i, strike, strong, sub, sup, u`) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.
Enter the code shown (prevents robots):
Live Comment Preview