Is it possible that you are trying to insert a null where a field does not allow nulls? Or perhaps you are trying to update the child before the parent (a foreign key issue)?

Have you trie checking the datatable's hasErrors property in the dataset and then invoking the GetErrors method on each of the tables with errors. It should return a collection of datarows. Look at the rowError property on each. You could try setting .enableconstraints on the dataset to false before the fill so you can watch the errors.

(Sorry, I seem to be making a lot of typos today)


>I have a SQL command that I cannot execute from my application. The message is:
>
>"Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."
>
>However, if I execute that SQL from SSMS, it works.
>
>So, I would like to know what it means exactly and why is it working from the SSMS environment?