Return Values and SqlHelper

[riversmithco]

Does anyone have an example of getting a return value back from a
stored proc using the SqlHelper data block? This should be so easy!

Here is my stored proc:


CREATE PROCEDURE AddEmployee
(
@SessionID varchar(24),
@EmployeeID varchar(6)
)
AS


IF (SELECT COUNT(*) FROM Employees WHERE EmployeeID = @EmployeeID) = 0

BEGIN

INSERT INTO Employees
(
SessionID,
EmployeeID

)
VALUES
(
@SessionID,
@EmployeeID
)

RETURN 1

END

ELSE

RETURN 0
GO


Thanks

 

[NuTcAsE]

Havnt used SqlHelper block but im assuming its a wrappeter over the
existing ado.net architecture. If there is a function to add Parameters
to a command, then you can create a command of type int and set its
direction to ReturnValue. That should get the return value back from
the database.

 

[NuTcAsE]

Oops sorry... its create a parameter an not command.

My bad

NuTcAsE