protected void btnSave_Click(object sender, EventArgs e) { PhanCongCNDTO dto = new PhanCongCNDTO(); dto.MaGV = Convert.ToInt16(ddlmagv.Text); dto.MaLop = ddlmalop.Text; dto.NamHoc = txtnamhoc.Text; dto.HocKy = Convert.ToInt16(txthk.Text); bll.SavePCGV(dto); Clear(); FillGridView(); }
public void SavePCGV(PhanCongCNDTO pc) { string sql1 = "insert into PhanCongChuNhiem values(@malop,@namhoc,@hocky,@magv)"; dl.getConn(); SqlCommand cmd = new SqlCommand(); cmd.Connection = ConnectDAL.cnn; cmd.CommandText = sql1; cmd.Parameters.AddWithValue("@malop", pc.MaLop); cmd.Parameters.AddWithValue("@namhoc", pc.NamHoc); cmd.Parameters.AddWithValue("@hocky", pc.HocKy); cmd.Parameters.AddWithValue("@magv", pc.MaGV); cmd.ExecuteNonQuery(); ConnectDAL.cnn.Close(); }