Hi, I have a simple select query off of one table in my oracle database. I am using a where clause to search records added between two dates. If I go to configure my data adapter the query works fine. However, when I am populating the query results to the dataset I am receiving,
"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."
I can still get the row count number from the result set but I cannot populate my datagrid because I cannot seem to get rid of this error.
Does anyone have any ideas? I think it probably has something to do with passing the dates (because I can get rid of the error by getting rid of the Where clause) but I haven't had any luck so far.
Thanks,
Jim
"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."
I can still get the row count number from the result set but I cannot populate my datagrid because I cannot seem to get rid of this error.
Does anyone have any ideas? I think it probably has something to do with passing the dates (because I can get rid of the error by getting rid of the Where clause) but I haven't had any luck so far.
Thanks,
Jim