My guess is that your typed dataset is expecting all your columns from the backend. You could look at the class to confirm this. The error can occur when the Typed DataSet class expects the column but the fill never includes it.

>It is a typed dataset. Should I change my select statement to select all the columns?
>
>>By chance, are you using typed datasets or untyped datasets? This error can occur if you use typed datasets and then modify the select statement to only include some of the columns.
>>
>>>All,
>>>
>>> I getting the message below when trying to fill a dataset. I am stumped, please help.
>>>
>>>"Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints"