protected void Page_Load(object sender, EventArgs e)
{
using (CustomersTableEntities myEntities = new CustomersTableEntities()){
var customerList = from customer in myEntities.Customers select customer;
GridView1.DataSource = customerList.ToList();
GridView1.DataBind();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
using (CustomersTableEntities myEntities = new CustomersTableEntities())
{
GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
int id = int.Parse(row.Cells[0].Text);
Customer customerToDelete = myEntities.Customers.Where(c => c.Id == id).FirstOrDefault();
myEntities.Customers.Remove(customerToDelete);
myEntities.SaveChanges();
}
}
public void DetailsView1_InsertItem()
{
Customer newCustomer = new Customer();
TryUpdateModel(newCustomer);
if (ModelState.IsValid)
{
using (var myEntities = new CustomersTableEntities())
{
myEntities.Customers.Add(newCustomer);
myEntities.SaveChanges();
}
}
}
