cannot insert the database SQL server

Sowbarani Karthikeyan

10y1.2k.NET

the insert query working for SQL SERVER 2008

insert into tblTotal(Id,User_Name,Company_Name,Product_Name,MRP,Salon_Cost,Qty,Total_Cost)values('1','Charu','hhwq','gfh','343','65','3','3546')

it can be working...

but my .Net page

string sql = "INSERT INTO tblTotal (Id,User_Name,Company_Name,Product_Name,MRP,Salon_Cost,Qty,Total_Cost) VALUES (@Id,@User_Name,@Company_Name,@Product_Name,@MRP,@Salon_Cost,@Qty,@Total_Cost)";

SqlCommand cmd = new SqlCommand(sql, con);

{

con.Open();

cmd.Parameters.AddWithValue("@Id", lblGrandTotal.Text);

cmd.Parameters.AddWithValue("@User_Name", lbUserName.Text);

cmd.Parameters.AddWithValue("@Company_Name", Wella.Text);

cmd.Parameters.AddWithValue("@Product_Name", g1.Cells[0].Text);

cmd.Parameters.AddWithValue("@MRP", g1.Cells[1].Text);

cmd.Parameters.AddWithValue("@Salon_Cost", g1.Cells[2].Text);

cmd.Parameters.AddWithValue("@Qty", Qty.Text);

cmd.Parameters.AddWithValue("@Total_Cost", Total_Cost.Text);

cmd.ExecuteNonQuery();

con.Close();

this code is some kind of error..

The INSERT statement conflicted with the FOREIGN KEY constraint "FKtblTotalUser_N__33D4B598". The conflict occurred in database "RESPONSIVE", table "dbo.tblResponsive", column 'User_Name'.
The statement has been terminated.

i didn't know what kind of mistake

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munesh Sharma10y ago
http://stackoverflow.com/questions/2965837/insert-statement-conflicted-with-the-foreign-key-constraint
ali tuncer10y ago
you don't have a column named Id in tblTotal table..but it is in Insert statement..
also, check the value of lbUserName.Text, it has to exist in tblResponsive User_Name column..because it is a foreign key..
Sowbarani Karthikeyan10y ago
CREATE TABLE tblResponsive(
user_id int identity(1,1),
User_Name varchar(50) primary key ,
Password varchar(50),
User_Type varchar(50),
Email varchar(100))

this is my primary key table..

create table tblTotal(
User_Name varchar(50) Not Null FOREIGN KEY REFERENCES tblResponsive(User_Name),
Company_Name varchar(100),
Product_Name varchar(100),
MRP varchar(100),
Salon_Cost varchar(100),
Qty varchar(100),
Total_Cost varchar(100),
OrderDate date NOT NULL DEFAULT GETDATE())

this is my foreign key table

what mistake i do...
Cassie Mod10y ago
your problem lies in the SQL database. Your foreign key is wrong
Sowbarani Karthikeyan10y ago
foreign key concept working very well in database side query but this not working c# server side what is the reason these show these kind of error
ali tuncer10y ago
User_Name(lbUserName.Text) you are trying to insert to tblTotal does not exist in tblResponsive..
Sowbarani Karthikeyan10y ago
these links are not getting to clear idea....
Ankur Mistry10y ago
hi,
Please check.

http://www.codeproject.com/Questions/365055/INSERT-statement-conflicted-with-the-FOREIGN-KEY-c
Bhushan Gawale10y ago
You might want to take a look at links below

http://stackoverflow.com/questions/2965837/insert-statement-conflicted-with-the-foreign-key-constraint

http://stackoverflow.com/questions/24812230/the-insert-statement-conflicted-with-the-foreign-key-same-table-constraint

cannot insert the database SQL server

The INSERT statement conflicted with the FOREIGN KEY constraint "FK__tblTotal__User_N__33D4B598". The conflict occurred in database "RESPONSIVE", table "dbo.tblResponsive", column 'User_Name'.The statement has been terminated.

The INSERT statement conflicted with the FOREIGN KEY constraint "FKtblTotalUser_N__33D4B598". The conflict occurred in database "RESPONSIVE", table "dbo.tblResponsive", column 'User_Name'.
The statement has been terminated.