private void GetData()
{
SampleDataContext dbContext = new SampleDataContext();
GridView1.DataSource = dbContext.Employees;
GridView1.DataBind();
}
} //end of btnUpdate
protected void btnDelete_Click(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
Employee obj2 = dbContext.Employees.SingleOrDefault(delete => delete.ID == 5);
dbContext.Employees.DeleteOnSubmit(obj2);
dbContext.SubmitChanges();
}//end of using
GetData();
}
} //end of btnInsert
protected void btnUpdate_Click(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
Employee obj1 = dbContext.Employees.SingleOrDefault(update => update.ID == 5);
obj1.Salary = 65500;
dbContext.SubmitChanges();
} //end of using
GetData();
} //end of btnUpdate
protected void btnInsert_Click(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
Employee obj = new Employee
{
ID = 6,
FirstName = "Shravani",
LastName = "Deshpande",
Gender = "Female",
DeptID = 3,
Salary = 66000
};
dbContext.Employees.InsertOnSubmit(obj);
dbContext.SubmitChanges();
} //end of using
GetData();
} //end of btnInsert
