protected void Button4_Click(object sender, EventArgs e) { DbCompanyEntities ce = new DbCompanyEntities(); short empno = short.Parse(TxtEmpno.Text); Emp context = ce.Emps.SingleOrDefault(col => col.Empno == empno); ce.DeleteObject(context); ce.SaveChanges(); }
protected void Button3_Click(object sender, EventArgs e) { DbCompanyEntities ce = new DbCompanyEntities(); short empno = short.Parse(TxtEmpno.Text); Emp context = ce.Emps.SingleOrDefault(col => col.Empno == empno); context.Ename = TxtName.Text; context.Job = TxtJob.Text; context.Salary = short.Parse(TxtSalary.Text); ce.SaveChanges(); }
protected void Button1_Click(object sender, EventArgs e) { #region Create a record Emp rec = new Emp(); rec.Empno = short.Parse(TxtEmpno.Text); rec.Ename = TxtName.Text; rec.Job = TxtJob.Text; rec.Salary = short.Parse(TxtSalary.Text); #endregion #region Add employ into db and save changes DbCompanyEntities dce = new DbCompanyEntities(); dce.AddToEmps(rec); dce.SaveChanges(); #endregion }