The INSERT statement conflicted with the FOREIGN KEY constraint

Question

5.00/5 (2 votes)

See more:

ok so i have two web forms in which data is being added into two tables. one table has a FK which refers to the other table primary key. in the second web form i insert values in to the form and want to store it in the db...but i get an error

"The INSERT statement conflicted with the FOREIGN KEY constraint "FK__StuDetail__eduid__5AA469F6". The conflict occurred in database "Dunstan_DB", table "dbo.EduDetails", column 'eduid'.
The statement has been terminated.

wat is the problem and how can it be resolved ?

Posted 10-Nov-11 17:50pm

Dunstan89

Updated 10-Nov-11 17:57pm

v2

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tejas Vaishnav · Answer 1 · 2011-11-10T18:20:00

as you say you have two tables....
so you have to fire insert query in primary key table first and get a identity value means newly added records primary key and then after completion of that process you have to fire second insert query with inserting a value in the FOREIGN key that is the out putted primary key from the first insert query...

IF YOU USE A STORE PROCEDURE THEN USE QUERY LIKE THIS....

SQL

INSERT INTO "FIRSTTABLE" (YOUR COLUMN LIST) VALUES (VALUES TO BE INSERTED)

SQL

DECLARE @IDENTITY INT 
INSERT INTO TABLE1(USERNAME,PASSWORD) VALUES ('test','test')
SELECT @IDENTITY =  @@IDENTITY FROM TABLE1
INSERT INTO TABLE2(USERID,FIRSTNAME,LASTNAME,MOBILENO) VALUES (@IDENTITY,'test','test','xxxx')
SELECT * FROM TABLE1
SELECT * FROM TABLE2

OR IF YOU NOT USE A STORE PROCEDURE AND USE ONLY TEXT QUERY THEN USE THIS...

SQL

--first insert data to table 1 contains primary key
INSERT INTO USERDETAIL(USERNAME,PASSWORD) VALUES ('test','test')
--select IDENTITY value of last inserted record means primary key
-- you can use any of this select query for that
SELECT TOP 1 ID FROM USERDETAIL ORDER BY ID DESC
--OR 
SELECT MAX(ID) FROM USERDETAIL
-- fill you resulted data in you container for use..
--fire insert query on second table containing FK
-- here use the data returnd from your select query..
INSERT INTO USERPERSONALDETAIL(USERID,FIRSTNAME,LASTNAME,MOBILENO) VALUES ('your select query data','test','test','xxxx')

you have to tack care of relation ship while using parent child relation in database...
you got that error because of that reason....

Pete _BSC · Answer 2 · 2011-11-10T18:10:00

Solution 1

Based on the error, you have a relationship between your tables and the FK value (column: eduid) you are inserting is not in the "other table".

Here is a good explanation of relationships[^].

Posted 10-Nov-11 18:10pm

Pete _BSC

member60 · Answer 3 · 2011-11-10T18:31:00

Solution 4

The error message is clear. You have specified key values that doesn't exist in the parent table.

Posted 10-Nov-11 18:31pm

member60

Dunstan89 · Answer 4 · 2011-11-10T20:01:00

Solution 5

thanks for the help guy i managed to resolve the problem :)

Posted 10-Nov-11 20:01pm

Dunstan89

Comments

Pete _BSC 22-Nov-11 15:16pm

IF any of the above items helped you, mark them as the solution or make this your solution and explain how you fixed it (for future readers).

Briga85 3-Oct-12 9:12am

I have the same problem...I have to insert in a second table an item that not have to appear in the first one...how you solved your problem?

srinivasadari 9-Jan-13 4:40am

I'm facing the same problem.I have to insert primary key and foreign key values in both tables from asp.net application.The newly coming value is primary key and foreign key at a time.If any help it would be appreciated..

moneymakermaster · Answer 5 · 2011-11-10T18:13:00

Solution 2

Check the data from web forms such that you are entering a column value which is not present in the primary key column.

http://www.w3schools.com/sql/sql_foreignkey.asp[^]

Posted 10-Nov-11 18:13pm

moneymakermaster