I am doing a query to the DB to return last week web orders and produce a CSV file for the reporting.
All I have done now, is created a View using the query below and defined a dataset (XSD) to pull these records...
When I have records with more than one orderID its giving me an error in the ASP.net script
System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
please can someone advise how to bypass this exception in ASP.NET?