Link to home
Start Free TrialLog in
Avatar of KaranGupta
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
ASKER CERTIFIED SOLUTION
Avatar of santhimurthyd
santhimurthyd
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial