private void deleteWrapper(DataGridViewSelectedRowCollection listSelectWrapper) { try { foreach (DataGridViewRow k in listSelectWrapper) { using (EntrepotBDDataContext db = new EntrepotBDDataContext()) { string name = k.Cells["name"].Value.ToString(); tb_capa wrapper = (from b in db.tb_capas where b.capa == name select b).FirstOrDefault(); db.tb_capas.DeleteOnSubmit(wrapper); db.SubmitChanges(); } } MessageBox.Show("success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); chargeGridView(); chargeCombo(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button14_Click(object sender, EventArgs e) { try { using (EntrepotBDDataContext db = new EntrepotBDDataContext()) { tb_capa wrapper = new tb_capa(); wrapper.capa = textBox3.Text; db.tb_capas.InsertOnSubmit(wrapper); db.SubmitChanges(); chargeCombo(); MessageBox.Show("success", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); textBox3.Clear(); chargeGridView(); textBox3.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }