The INSERT statement conflicted with the FOREIGN KEY constraint "FK_CheckInCheckOut_Employee". The conflict occurred in database "EmployeeRecord", table "dbo.Employee", column 'empId'. The statement has been terminated.
protected void imgbtnUpadteDB(object sender, ImageClickEventArgs e) { DBClassesDataContext db = new DBClassesDataContext(); CheckInCheckOut chk = new CheckInCheckOut(); Employee em = new Employee(); chk.checkTime = System.DateTime.Now; if (chk.checkTime != null) { chk.checkTime = DateTime.Now; } else { chk.checkoutTime = DateTime.Now; } empId = 1; em.name = txtCheckIn.Text; db.CheckInCheckOuts.InsertOnSubmit(chk); db.Employees.InsertOnSubmit(em); db.SubmitChanges(); Response.Redirect("Default.aspx"); }
db.CheckInCheckOuts.InsertOnSubmit(chk); db.Employees.InsertOnSubmit(em); 1st statement should be db.Employees.InsertOnSubmit(em); Then 2nd statement should be db.CheckInCheckOuts.InsertOnSubmit(chk);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)