Exemplo n.º 1
0
        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);
            }
        }
Exemplo n.º 2
0
        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);
            }
        }