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(); }
public List <SV_MH> GetSV_MH(string sql) { try { SqlDataReader dr = dp.ExecReader(sql); List <SV_MH> list = new List <SV_MH>(); int masv; string mamh; double diem; while (dr.Read()) { masv = dr.GetInt32(0); mamh = dr.GetString(1); diem = dr.GetDouble(2); SV_MH smh = new SV_MH(masv, mamh, diem); list.Add(smh); } return(list); } catch (Exception ex) { throw ex; } finally { dp.disCon(); } }
public int SuaSV_MH(SV_MH SV_MH) { try { return(new SV_MHDAO().SuaSV_MH(SV_MH)); } catch (Exception ex) { throw ex; } }
public int SuaSV_MH(SV_MH SV_MH) { List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@masv", SV_MH.MaSV)); list.Add(new SqlParameter("@mamh", SV_MH.MaMH)); list.Add(new SqlParameter("@diem", SV_MH.Diem)); try { return(dp.ExcuteNonquery("SuaSV_MH", System.Data.CommandType.StoredProcedure, list)); } catch (Exception ex) { throw ex; } }