insert and return vales from a sproc

[darenkov]

Hi,

 

I have created a sproc which inserts some data and also returns the user_id via the scope_identity().

 

My problem is that I am not having any luck getting the return value when executing the sproc in my asp.net (vb) app. The data seems to insert fine but not the return value I want.

 

Is anyone familiar with how this can be done using the CommandType.StoredProcedure method etc?

 

cheers

[mocella]

You could use an output parameter to hold this value, or use exec_scalar and use a return in your proc.

 

Of course, I'm assuming you're doing SQL2K when I suggest these options. Either would work.