Command.ExecuteNonquery()

Question

when am trying to execute a stored proc by using command.executenonquery() it was giving me the return value as -1 where I have to get 1 value. In the stored proc am doing inserting and updating  am inserting the orderid from order table into orderevent table(which has a trigger on orderevent table) and updating the status of an order in order table please if anyone knows the solution let me know . Thanks in advance

Jignesh Trivedi · Answer

hi it might your store procedure has no return value. you can specify the return value using return keyword Like Create proc #testsp as begin insert into #temp values(1) return 0 end hope this will help you.

Kunal Vaishya · Answer

Hi PLease share your stored procedure for this issu so then we can investigate.