Stored Procedures

[sroberts82]

Hi,
I have a stored procedure and it looks like the following

ALTER PROCEDURE USP_NCUInsertContentCodeTest
@var1 int,
@var2 int
etc

AS

DECLARE @RC int

//Do stuff

RETURN @RC

I know how to execute the procedure in c# but I cant figure out how to get the return value. I know if I declared the @RC before the AS I could declare it as a parameter with parameterdirectio = output etc but I cannot change the stored procedure. How can I do it?
Thank you in advance,
Ste

 

[NeilTrain]

which method are you using to call it?

For a SP that returns a single integer, I would use the ExecuteScalar() method, which returns an object, which I would then cast to an integer.

 

[phinoppix]

Try adding a parameter to your command object with ParameterDirection = ReturnValue.


ocmd.Parameters.Add("RETURN", ..., ParameterDirection.ReturnValue, ...)

ocmd.Execute...

int value = (int)ocmd.Parameters["RETURN"];