protected void BtmUpdate(object sender, EventArgs e) { using (SampleDataContext dbContext = new SampleDataContext()) { Employees employee = dbContext.Employees.SingleOrDefault(x => x.ID == 8); employee.Salary = 65000; dbContext.SubmitChanges(); } GetData(); }
protected void BtmDelete(object sender, EventArgs e) { using (SampleDataContext dbContext = new SampleDataContext()) { try { Employees employee = dbContext.Employees.SingleOrDefault(x => x.ID == 10); dbContext.Employees.DeleteOnSubmit(employee); dbContext.SubmitChanges(); } catch (Exception ex) { ExceptionMethod(ex); } } GetData(); }
protected void BtmInsert(object sender, EventArgs e) { try { using (SampleDataContext dbContext = new SampleDataContext()) { Employees newEmployee = new Employees { FirstName = "jean", LastName = "Fred", Gender = "Male", Salary = 50000, DepartmentId = 1, }; dbContext.Employees.InsertOnSubmit(newEmployee); dbContext.SubmitChanges(); } GetData(); } catch (Exception ex) { ExceptionMethod(ex); } }