private void deleteSize(DataGridViewSelectedRowCollection listSelectSize) { try { foreach (DataGridViewRow k in listSelectSize) { using (EntrepotBDDataContext db = new EntrepotBDDataContext()) { string name = k.Cells["name"].Value.ToString(); tb_vitola size = (from b in db.tb_vitolas where b.vitola == name select b).FirstOrDefault(); db.tb_vitolas.DeleteOnSubmit(size); db.SubmitChanges(); } } MessageBox.Show("success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); chargeGridView(); chargeCombo(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button12_Click(object sender, EventArgs e) { try { using (EntrepotBDDataContext db = new EntrepotBDDataContext()) { tb_vitola size = new tb_vitola(); size.vitola = textBox2.Text; db.tb_vitolas.InsertOnSubmit(size); db.SubmitChanges(); chargeCombo(); MessageBox.Show("success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); textBox2.Clear(); chargeGridView(); textBox2.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }