0 out of 3 rated this helpful - Rate this topic

Troubleshooting Exceptions: System.Data.ConstraintException

A ConstraintException exception is thrown when an action is attempted that violates a constraint.

Relax or turn off constraints in your DataSets.

You can use the EnforceConstraints property to temporarily turn off constraints while filling tables in a DataSet object.

Make sure you are not trying to assign a value to a primary key field where the primary key already exists in the data table.

If the primary key exists, this exception is thrown.

Clear datasets before loading them from view state.

If there is data in the dataset when you load it, this exception may be thrown.

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.