How to get value return by a Store Procedure

Topics: Data Access Application Block
Nov 24, 2007 at 7:16 AM
Hi! All
I m inserting record in a table by store procedure which return me id of that record; which is used to a reference for other table. Record is inserted successfully but i did not get id of that record; because id is not an output parameter but it is return by store procedure with return keyword. so, how do i tackle this?
any suggestion regarding this will be anticipated.
Nov 24, 2007 at 1:56 PM
I solve above problem by: indicating the parameter direction as Returnvalue while passing to the command object.
It works fine.