private void btnThemCV_Click(object sender, EventArgs e) { PhanCong_ViTri temp = new PhanCong_ViTri(txtMaNV.Text, txtMaVT.Text); ConnectDatabase.SuaViTri_NhanVien(temp); dgvPCVT.DataSource = ConnectDatabase.PhanCongViTri(); }
public static void SuaViTri_NhanVien(PhanCong_ViTri p) { string sql = "UPDATE NHANVIEN_VITRI set MaVT=@mavt where MaNV=@manv"; using (SqlCommand command = new SqlCommand(sql, conn)) { command.Parameters.Add(new SqlParameter("@manv", p.MaNV1)); command.Parameters.Add(new SqlParameter("@mavt", p.MaVT1)); command.ExecuteNonQuery(); command.Cancel(); } }