Data Filling error after Relation

melvik · July 6th, 2003, 09:10 AM

I have made a Relation in my 2 Tables but when I wanna fill the DataSet by DataAdapter It Gives me following error:

Code:

An unhandled exception of type 'System.Data.ConstraintException' occurred in system.data.dll

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

PLEASE HELP ME, I become stuck in this simple problem!!!

Always:),
Hovik Melkomian.

smittynh · July 31st, 2003, 09:00 AM

When you fill the dataset using the data adapter's fill method, make sure you fill the parent table before the child table. This worked for me.

datagram · December 29th, 2004, 06:19 PM

DataSet11.EnforceConstraints = False