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

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

 

(http://forums.asp.net/p/1154874/1901799.aspx#1901799)