public bool ADD(ChamCongCS chamcong) { string sql = @"insert into ChamCong values(@mcc,@mnv,@trangthai,@thang,@nam)"; SqlConnection cn = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.AddWithValue("@mcc", chamcong.Mcc); cmd.Parameters.AddWithValue("@mnv", chamcong.Mnv); cmd.Parameters.AddWithValue("@trangthai", chamcong.Trangthai); cmd.Parameters.AddWithValue("@thang", chamcong.Thang); cmd.Parameters.AddWithValue("@nam", chamcong.Nam); cn.Open(); int dem = cmd.ExecuteNonQuery(); cn.Close(); return(dem >= 1); }
protected void btncapnhat_Click(object sender, EventArgs e) { string mcc = Txtmacc.Text; // ép kiểu mnv. int mnv = int.Parse(Ddlmanv.SelectedValue.ToString()); string trangthai = Ddltrangthai.SelectedValue.ToString(); string thang = ddlthang.SelectedValue.ToString(); string nam = txtnam.Text; ChamCongCS cc = new ChamCongCS(mcc, mnv, trangthai, thang, nam); if (qlchamcong.ADD(cc)) { lbthongbao.Text = "Thêm thành công!"; GVNV.DataSource = qlchamcong.getTalbe("select * from ChamCong"); GVNV.DataBind(); } else { lbthongbao.Text = "Thêm thất bại"; } }