Error filling typed DataSet with relations

P

Pi

Hey guys,

In my schema I have created various relationships between tables in my
dataset. However when I attempt to fill the data set I get a
ConstraintException with the message Failed to
enable constraints. One or more rows contain values violating
non-null, unique, or foreign-key constraints. the
keys that the relations are set to nullable.

Does anyone have any idea?

Regards,
Tommy
 
M

Mohamoss

Hi Tommy
this means that one of the data items that you want to fill the dataset
with violates the constrains that specify in your constrains?? so you need
to get back to your data and make sure of it . one way to over come this is
to use "System.Data.XmlReadMode.IgnoreSchema' when you fill data into your
dataset.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dataset - Relations vb 2005 3
Dataset constrain error 2
DataAdapter.FillError event does not fire 1
DataSet constraints 1
VS2005 Strongly Typed DS and Mutliple Result Set 1
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign 1
DataAdapter.Fill order 4
Constraint error on DataSet filll 7

Top