I use the Msoft example  in "working with data in asp.net 2.0- creating a
business logic layer" as below to insert a record which I have entered in a
formview. I would like to follow this by displaying the inserted record
rather than returning to an arbitrary record in Edit mode - but I don't have
ithe new productID, only the number of rows affected.

products.addProductsRow(product)
dim rowsAffected as integer = adapter.update(products)
return rowsAffected = 1

Could anyone suggest how I might obtain the new productID while still using
the procedure above?

Nested Properties in a GridView ASP.Net 2.0
TemplateBuilder
Drop Down Box Validation Problem
remove border around checkboxes
Need Help with Control Selection
usercontrols and postback
Calendar control - disabling past dates.
Rendering the ItemStyle of a GridView row
DetailView Question
Login Control not using skin defaults?