Friday, February 28, 2014

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

  • Windows App C# มัน runtime exception หว่า
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Solved
dataset.TableA.Clear();
dataset.EnforceConstraints = false;
dataAdapter1.daTableA.Fill(dataset, TableA");
Refer
  • http://www.vbforums.com/showthread.php?737541-RESOLVED-Failed-to-enable-constraints-One-or-more-rows-contain-values-violating-non-null
  • http://stackoverflow.com/questions/7026566/failed-to-enable-constraints-one-or-more-rows-contain-values-violating-non-null

No comments:

Post a Comment