private void GetData()
{
SampleDataContext dbContext = new SampleDataContext();
GridView1.DataSource = dbContext.Employees;
GridView1.DataBind();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
Employee employee = dbContext.Employees.SingleOrDefault(emp => emp.ID == 8);
dbContext.Employees.DeleteOnSubmit(employee);
dbContext.SubmitChanges();
}
GetData();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
Employee employee = dbContext.Employees.SingleOrDefault(emp => emp.ID == 8);
employee.Salary = 65000;
dbContext.SubmitChanges();
}
GetData();
}
protected void btnInsert_Click(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
Employee newEmployee = new Employee
{
FirstName = "Tim",
LastName = "T",
Gender = "Male",
Salary = 55000,
DepartmentId = 1
};
dbContext.Employees.InsertOnSubmit(newEmployee);
dbContext.SubmitChanges();
}
GetData();
}