(XIN LOI VI MAY MINH KO GO DUOC TIENG VIET)
Minh co hai bang HUYEN va TINH minh muon xoa du lieu tu HUYEN. Minh su dung cau lenh SQL va trong chuong trinh co 1 thu tuc Xoa(). Day la thu tuc cua minh:
public void Xoa()
{
SqlConnection sqlCon = new SqlConnection(ConStr);
SqlCommand sqlCmd = new SqlCommand("Huyen_Xoa", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter sqlPar = new SqlParameter();
sqlPar = sqlCmd.Parameters.Add(@"Mahuyen", SqlDbType.NVarChar);
sqlPar.Direction = ParameterDirection.Input;
sqlPar.Value = Mahuyen;
sqlCon.Open();
sqlCmd.ExecuteNonQuery();
sqlCon.Close();
}
Minh dung 1 button trong winform de xoa nhung ko thanh cong va cung ko thay bao loi gi. Ai biet xin chi giup minh voi. Thank!
Minh co hai bang HUYEN va TINH minh muon xoa du lieu tu HUYEN. Minh su dung cau lenh SQL va trong chuong trinh co 1 thu tuc Xoa(). Day la thu tuc cua minh:
public void Xoa()
{
SqlConnection sqlCon = new SqlConnection(ConStr);
SqlCommand sqlCmd = new SqlCommand("Huyen_Xoa", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter sqlPar = new SqlParameter();
sqlPar = sqlCmd.Parameters.Add(@"Mahuyen", SqlDbType.NVarChar);
sqlPar.Direction = ParameterDirection.Input;
sqlPar.Value = Mahuyen;
sqlCon.Open();
sqlCmd.ExecuteNonQuery();
sqlCon.Close();
}
Minh dung 1 button trong winform de xoa nhung ko thanh cong va cung ko thay bao loi gi. Ai biet xin chi giup minh voi. Thank!