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

 I managed to solve it in the end.  Right click the table adapter and there is an option to delete the primary key(s).  Then it worked.

http://forums.asp.net/t/1154874.aspx