Beispiel #1
0
        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();
            }
        }