Retrieving return value of stored procedure(NOT OutPut Parameter)

Question

I created a SP which is having
one input parameter
one output parameter
and one return value which got displayed on the text window of the query analyzer
Now I am unable to get that value
can anyone of you help me out

best regards
Rahul Goel

Lee Blake · Answer

sqlDaBewerber.InsertCommand.Parameters [@weitereInfo] .Value = txtDStudiumInfo.Text ; sqlDaBewerber.InsertCommand.Parameters [@LetzterAenderer] .Value = Session [UserName] .ToString (); sqlDaBewerber.InsertCommand.ExecuteNonQuery (); Session [StudiumID] = Convert.ToInt32 ( sqlDaBewerber.InsertCommand.Parameters [@RETURN_VALUE] .Value ); Here is how I did it.