private void button3_Click(object sender, EventArgs e) { RestaurantDBDataContext rb = new RestaurantDBDataContext(); int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value); Restaurant r = rb.Restaurants.FirstOrDefault(s => s.id == id); rb.Restaurants.DeleteOnSubmit(r); rb.SubmitChanges(); bindgridview(); }
private void insert_Click(object sender, EventArgs e) { db = new RestaurantDBDataContext(); r = new Restaurant(); r.id = int.Parse(idbox.Text); r.name = namebox.Text; r.rooms = int.Parse(roombox.Text); r.city = citybox.Text; db.Restaurants.InsertOnSubmit(r); db.SubmitChanges(); bindgridview(); }
private void update_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { RestaurantDBDataContext rb = new RestaurantDBDataContext(); int id = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value); Restaurant rr = rb.Restaurants.FirstOrDefault(s => s.id == id); rr.id = int.Parse(idbox.Text.ToString()); rr.name = namebox.Text.ToString(); rr.city = citybox.Text.ToString(); rr.rooms = int.Parse(roombox.Text.ToString()); rb.SubmitChanges(); bindgridview(); } else { MessageBox.Show(" SELECT SOMETHING BUDDY "); } }
public void bindgridview() { db = new RestaurantDBDataContext(); dataGridView1.DataSource = db.Restaurants; }