コード例 #1
0
        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);
            }
        }
コード例 #2
0
        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);
            }
        }