private void button4_Click(object sender, EventArgs e) { int masv; string mamh; double diem; masv = int.Parse(txtmsv.Text.Trim()); mamh = txtmmh.Text.Trim(); diem = double.Parse(txtdiem.Text.Trim()); SV_MH sh = new SV_MH(masv, mamh, diem); try { int i = new SV_MHBus().SuaSV_MH(sh); if (i == -2) { throw new Exception(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } dgvSV_MH.DataSource = GetSV_MH(); }
private List <SV_MH> list2() { string sql = @"Select * from SV_MH where MaSV='" + txttim.Text + "'"; SV_MHBus mh = new SV_MHBus(); List <SV_MH> list2 = mh.GetSV_MH(sql); return(list2); }
public List <SV_MH> GetSV_MH() { try { string sql = "Select * from SV_MH"; SV_MHBus SV_MH = new SV_MHBus(); return(SV_MH.GetSV_MH(sql)); } catch (Exception ex) { throw ex; } }
private void button5_Click(object sender, EventArgs e) { int masv; string mamh; masv = int.Parse(txtmsv.Text.Trim()); mamh = txtmsv.Text.Trim(); try { int i = new SV_MHBus().XoaSV_MH(masv, mamh); if (i == -2) { throw new Exception(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } dgvSV_MH.DataSource = GetSV_MH(); }