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(); } } }