I am using a stored procedure to insert into my table from my DAL.
The stored procedure ends with return @@scope_identity
I now want to access that in my BLL so I can return it back to the objectdatasource inserted event and then use it on my page.
retval = Adapter.Update(mytable)
always returns the records affected (which is 1). how do i get this value?