//Видалення
protected void Button5_Click(object sender, EventArgs e)
{
SampleDataContext dbContext = new SampleDataContext();
var deps = (
from department in dbContext.Departments
where department.Name == "Support"
select department);
if (deps.Count() == 0)
{
return;
}
var dep = deps.First();
dbContext.Departments.DeleteOnSubmit(dep);
try
{
dbContext.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
GridView2.DataBind();
}
//Додати запис
protected void Button4_Click(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
Departments dep = new Departments();
dep.Location = "Ukraine";
dep.Name = "Support";
dbContext.Departments.InsertOnSubmit(dep);
try
{
dbContext.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
GridView2.DataBind();
}