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!
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER