I am trying to use a datawindow and insert a row with a stored procedure.

The table is very simple.  It just has an id and a name column.

The id column of the insert is an identity column.  The stored procedure returns the identity value when it completes.

What I don't know how to do is how to get the return value from the stored procedure so I can use it.  dw.Update() just gives me a value of 1.  Is there a way to do this or use an in/out parameter and get the value of it?

I have been running into issues trying to use the Declare Procedure pattern so I am looking into alternatives.