Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ExecSprocScalar and catch my return value
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Title:
ExecSprocScalar and catch my return value
Miscellaneous
Thread ID:
01115912
Message ID:
01115912
Views:
54
I have a SP that receives 12 params in and provides one out. I am following the help, but I am missing something. I get returned the 0, but my SP actually writes the proper RONumber in the db. :)

Code shows:
IDbCommand cmd;
this.ExecSprocScalar("Jobs_Insert", out cmd,
this.CreateParameter("@POnumber", POnumber),
this.CreateParameter("@CustomerID", CustomerID),
--sniped --
this.CreateParameter("@RONumber", 0));


// Retrieve the value from the command object
IDbDataParameter param = (IDbDataParameter)cmd.Parameters["@ROnumber"];
int x = (int)param.Value;
return x;

Any ideas?

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform