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