KaranGupta
asked on
update using sqlcommandbuilder
Hi
I am facing an issue in update query using sqlcommandbuilder class when I check the update command I find this command
UPDATE [subjects1] SET [SubjectCode] = @SubjectCode, [SubjectText] = @SubjectText, [IsSubjectActive] = @IsSubjectActive WHERE (([SubjectID] = @Original_SubjectID) AND ((@IsNull_SubjectCode = 1 AND [SubjectCode] IS NULL) OR ([SubjectCode] = @Original_SubjectCode)) AND ((@IsNull_SubjectText = 1 AND [SubjectText] IS NULL) OR ([SubjectText] = @Original_SubjectText)) AND ((@IsNull_IsSubjectActive = 1 AND [IsSubjectActive] IS NULL) OR ([IsSubjectActive] = @Original_IsSubjectActive) ))
but my table only contains the columns SubjectId, SubjectCode,SubjectText and IsSubjectActive from where does rest of the columns came
Regards
Karan Gupta
I am facing an issue in update query using sqlcommandbuilder class when I check the update command I find this command
UPDATE [subjects1] SET [SubjectCode] = @SubjectCode, [SubjectText] = @SubjectText, [IsSubjectActive] = @IsSubjectActive WHERE (([SubjectID] = @Original_SubjectID) AND ((@IsNull_SubjectCode = 1 AND [SubjectCode] IS NULL) OR ([SubjectCode] = @Original_SubjectCode)) AND ((@IsNull_SubjectText = 1 AND [SubjectText] IS NULL) OR ([SubjectText] = @Original_SubjectText)) AND ((@IsNull_IsSubjectActive = 1 AND [IsSubjectActive] IS NULL) OR ([IsSubjectActive] = @Original_IsSubjectActive)
but my table only contains the columns SubjectId, SubjectCode,SubjectText and IsSubjectActive from where does rest of the columns came
Regards
Karan Gupta
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.