Click here to Skip to main content
15,899,754 members
Home / Discussions / C#
   

C#

 
AnswerRe: Need Advice about Inserting [modified] Pin
fly90418-Mar-09 9:16
fly90418-Mar-09 9:16 
GeneralRe: Need Advice about Inserting Pin
soulidentities18-Mar-09 9:18
soulidentities18-Mar-09 9:18 
GeneralRe: Need Advice about Inserting Pin
fly90418-Mar-09 9:36
fly90418-Mar-09 9:36 
GeneralRe: Need Advice about Inserting Pin
soulidentities18-Mar-09 9:43
soulidentities18-Mar-09 9:43 
QuestionOutlook Macro/Addon Pin
partialdata18-Mar-09 8:58
partialdata18-Mar-09 8:58 
QuestionWhat's better : SmartCard or CardSpace ? [modified] Pin
hdv21218-Mar-09 8:35
hdv21218-Mar-09 8:35 
QuestionHelp cleaning up C# Code (WMI code) - Neewbie Pin
Buck_Murdock18-Mar-09 8:19
Buck_Murdock18-Mar-09 8:19 
QuestionForeignKeyConstraint requires the child key values to exist in the parent table! Pin
Lodeclaw18-Mar-09 8:17
Lodeclaw18-Mar-09 8:17 
Is the subject line too long? Probably.

I'm experiencing an issue with my dataset that seems to be telling me that the values for a foreign key in my child table does not exist within the parent table. As far as I can see, the value does exist. This happens when I try to fill a datagridview using a tableadapter.

If the program throws the exception as normal I get the usual "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."

If I use a try/catch around the query it fills the datagridview but gives me a red warning sign that reads "ForeignKeyConstraint [ForeignKey] requires the child key values (value) to exist in the parent table."

Has anyone come across this particular issue? Where can I usually find the properties for foreign key contraints?

Any help would be hugely appreciated!

(I'm using the generic Fill query created for tables in sqlserver.)
AnswerRe: ForeignKeyConstraint requires the child key values to exist in the parent table! Pin
Fayu18-Mar-09 9:58
Fayu18-Mar-09 9:58 
AnswerRe: ForeignKeyConstraint requires the child key values to exist in the parent table! Pin
Matt Graham24-Mar-11 7:44
Matt Graham24-Mar-11 7:44 
QuestionDatagridview cell painting Pin
Dan Neely18-Mar-09 8:11
Dan Neely18-Mar-09 8:11 
AnswerRe: Datagridview cell painting Pin
Henry Minute19-Mar-09 7:18
Henry Minute19-Mar-09 7:18 
GeneralRe: Datagridview cell painting Pin
Dan Neely19-Mar-09 8:02
Dan Neely19-Mar-09 8:02 
GeneralRe: Datagridview cell painting Pin
Henry Minute19-Mar-09 11:41
Henry Minute19-Mar-09 11:41 
GeneralRe: Datagridview cell painting Pin
Dan Neely20-Mar-09 5:36
Dan Neely20-Mar-09 5:36 
GeneralRe: Datagridview cell painting Pin
Henry Minute20-Mar-09 9:50
Henry Minute20-Mar-09 9:50 
GeneralRe: Datagridview cell painting Pin
Dan Neely20-Mar-09 10:12
Dan Neely20-Mar-09 10:12 
GeneralRe: Datagridview cell painting Pin
Henry Minute20-Mar-09 10:18
Henry Minute20-Mar-09 10:18 
AnswerRe: Datagridview cell painting Pin
Jake Myers29-Apr-09 22:34
Jake Myers29-Apr-09 22:34 
GeneralRe: Datagridview cell painting Pin
Dan Neely30-Apr-09 8:41
Dan Neely30-Apr-09 8:41 
GeneralRe: Datagridview cell painting Pin
Jake Myers1-May-09 4:20
Jake Myers1-May-09 4:20 
GeneralRe: Datagridview cell painting Pin
Dan Neely1-May-09 4:37
Dan Neely1-May-09 4:37 
GeneralRe: Datagridview cell painting [modified] Pin
Jake Myers1-May-09 5:06
Jake Myers1-May-09 5:06 
QuestionUnlocking account in AD Pin
Jacob Dixon18-Mar-09 7:53
Jacob Dixon18-Mar-09 7:53 
QuestionHelp understanding C# sockets Pin
John Joger18-Mar-09 7:47
John Joger18-Mar-09 7:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.