Abbasi
-
Posts
4 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by Abbasi
-
-
I am quoting a clear example of the Junction table, in Northwind sample database.When employing this database in a DataGrid, I receive DataConstraint Exception Error in the Junction table "Order Details" or in the "Orders" table, with the following error message:"Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."On displaying one of the errant tables, each row complains as below:"ForeignKeyConstraint, Shipper_Order (for example) requires the child key values ????? to exist in the parent table.NOTES: 1- I established Relations just according to the ones in MS Access application.2- The Same Database is Functioning normally inside MS Access application.3- I am mainly concerned about the Junction table.I need professional guidance as this is a study project, I am working on.
-
Yes, this is the DatatGrid. Unfortunately, I could not find any property relating to this feature - in DataGrid, its TableStyles or the GridColumnStyles properties.Seeking further help.
-
I need to include a column in an SQL Server table, which can hyperlink to some text stored somewhere inside or outside the same database.My ultimate goal is that when I view the table in a control, DataGrid for example, and click that link, it should take me to the destination link or open the linked file.Please help.R. A. Abbasi
DataConstraint Exception with Junction Table
in .NET
Posted
Thanks aspnetguy for the response. I found the reason of the problem. The sequence in which I filled the DataAdapters was not appropriate - the rule is load the Parent table before the Child table, otherwise meet the problem.