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);
