Link to home
Start Free TrialLog in
Avatar of bham3dman
bham3dman

asked on

How do I retrieve a ReturnValue from a stored procedure using a SQLDataSource control?

Greetings Experts,

I'm using a stored procedure that returns a record ID upon inserting new record data.  What is the easiest way to retrieve the ReturnValue from the stored procedure using a SQLDataSource control?

I've found the following code for inserting values (which seems easy enough) but I can't figure out how to retrieve the ReturnValue and store this value in a variable.  

Thanks for your help!
With sqldatasource1
                .InsertParameters("@Products").DefaultValue = Product
                .InsertParameters("@Manufacturer").DefaultValue = Manufacturer
                .InsertParameters("@Description").DefaultValue = Description
                .Insert()
End With

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Munawar Hussain
Munawar Hussain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bham3dman
bham3dman

ASKER

Sorry for the delayed response.  Thanks for the assistance.