i have a dataset which includes a method called HasRows:-
SELECT COUNT(ID) AS RecordCount
FROM Tbl_DegreeSubje cts
WHERE (StudentID = @StudentID) AND (SubjectName = @SubjectName)
neither StudentID or SubjectName columns contain null data, running the
query in Management Studio works correctly, constraints are disabled for the
dataset yet i get the message:-
Failed to enable constraints. One or more rows contain values violating
non-null, unique, or foreign-key constraints
any idea what is going on?
(I cannot change the design as it is not my app , i am just debugging it)
SELECT COUNT(ID) AS RecordCount
FROM Tbl_DegreeSubje cts
WHERE (StudentID = @StudentID) AND (SubjectName = @SubjectName)
neither StudentID or SubjectName columns contain null data, running the
query in Management Studio works correctly, constraints are disabled for the
dataset yet i get the message:-
Failed to enable constraints. One or more rows contain values violating
non-null, unique, or foreign-key constraints
any idea what is going on?
(I cannot change the design as it is not my app , i am just debugging it)