protected void btnDelete_Click(object sender, EventArgs ee) { LINQTOSQLDataContext lsql = new LINQTOSQLDataContext(); var employee = lsql.Employees.SingleOrDefault(e => e.ID == 11); lsql.Employees.DeleteOnSubmit(employee); lsql.SubmitChanges(); LoadData(); }
protected void btnInsert_Click(object sender, EventArgs e) { using (LINQTOSQLDataContext lsql = new LINQTOSQLDataContext()) { Employee emp = new Employee { FirstName = "Fancy", LastName = "Fateh", Gender = "Female", DepartmentId = 3, Salary = 1000000 }; lsql.Employees.InsertOnSubmit(emp); lsql.SubmitChanges(); } LoadData(); }