I want to have the user enter their data into the "insert" portion of a formview, click the insert button and have the system save the info, then return the user to the edit mode.
You'd think this would be pretty standard....
I figured there must be a better way to do this than writing a procedure to pull the identity. Isn't there some fancy dotnet option? Somewhere I saw someone using a select @@IDENTITY statement after the sql statement used on the insert option of the sql datasource.