private void btEdit_Click(object sender, EventArgs e) { //qlnv1 ql = new qlnv1(); try { ql = db.qlnv1s.Where(p => p.emID == txtemID.Text).Single(); ql.Name = txtName.Text; ql.Dept = txtDept.Text; db.SubmitChanges(); Form1_Load(sender, e); } catch (InvalidOperationException ne) { MessageBox.Show(ne.Message, "Thong Bao", MessageBoxButtons.OK); } }
private void btSave_Click(object sender, EventArgs e) { qlnv1 ql = new qlnv1(); try { ql.emID = txtemID.Text; ql.Name = txtName.Text; ql.Dept = txtDept.Text; db.qlnv1s.InsertOnSubmit(ql); db.SubmitChanges(); Form1_Load(sender, e); } catch (DuplicateKeyException ie) { MessageBox.Show(ie.Message, "Thong Bao", MessageBoxButtons.OK); } catch (SqlException se) { MessageBox.Show(se.Message, "Thong Bao", MessageBoxButtons.OK); } }
partial void Deleteqlnv1(qlnv1 instance);
partial void Updateqlnv1(qlnv1 instance);
partial void Insertqlnv1(qlnv1 instance);