Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

by

This problem is usually caused by one of the following

  • null values being returned for columns not set to AllowDBNull
  • duplicate rows being returned with the same primary key.
  • a mismatch in column definition (e.g. size of char fields) between the database and the dataset

Try running your query natively and look at the results, if the resultset is not too large. If you’ve eliminated null values, then my guess is that the primary key columns is being duplicated.

Or, to see the exact error, you can manually add a Try/Catch block to the generated code like so and then breaking when the exception is raised:

enter image description here

Then within the command window, call GetErrors method on the table getting the error.
For C#, the command would be ? dataTable.GetErrors()
For VB, the command is ? dataTable.GetErrors

enter image description here

This will show you all datarows which have an error. You can get then look at the RowError for each of these, which should tell you the column that’s invalid along with the problem. So, to see the error of the first datarow in error the command is:
? dataTable.GetErrors(0).RowError
or in C# it would be ? dataTable.GetErrors()[0].RowError

enter image description here

More Related Contents:

  1. How do I update a value in C# and SQL Server? [closed]
  2. Search SQL by date ASP.NET
  3. Sql: Incorrect syntax near ‘(‘ [closed]
  4. how to get date difference between two dates using DateDiff Excluding the weekends [duplicate]
  5. C# Data Connections Best Practice?
  6. Unable to cast object of type ‘System.DBNull’ to type ‘System.String`
  7. Insert 2 million rows into SQL Server quickly
  8. Is there a good LINQ way to do a cartesian product?
  9. Entering keys manually with Entity Framework
  10. Read SQL Table into C# DataTable
  11. Pass table valued parameter using ADO.NET
  12. How do I connect to an MDF database file?
  13. How do I connect to an .mdf (Microsoft SQL Server Database File) in a simple web project?
  14. SQL WHERE clause matching values with trailing spaces
  15. DropdownList DataSource
  16. How to access ssis package variables inside script component
  17. Stop SQL query execution from .net Code
  18. SqlConnection.Close() inside using statement
  19. What does N’ stands for in a SQL script ? (the one used before characters in insert script)
  20. ASP.NET ODBC Query with parameters
  21. What is passing parameters to SQL and why do I need it?
  22. How to make LINQ execute a (SQL) LIKE range search
  23. Index (zero based) must be greater than or equal to zero
  24. no overload for method “ToString” takes 1 arguments
  25. How to use String property as primary key in Entity Framework
  26. Populate TreeView from DataBase
  27. Database Error: There is no row at position 0
  28. Databind a dropdownlist
  29. Is SqlConnection.Close() need inside a Using statement?
  30. Update-Database command is not working in ASP.Net Core / Entity Framework Core because object in database already exists

Leave a Comment