Use New Inserted Autonumber ID as session variable
Posted on 2012-03-27
I am usually a PHP guy so I know basically nothing about .NET. I am using an INSERT Record Behavior in Dreamweaver (I know I should be using VS but DW is easier for me to navigate). I am using the basic insert record behavior and need to take that new IDENTITY line, store it in a session variable, and use it on the next page to insert it in another table with a FK so the tables relate.
I need code as again, I am new with .NET. I have found some articles on the web in forums to create a stored procedure, etc. but I think that would be too complicated for what I need. I have also been looking at Identity_Scope() but not sure I want to use that either.
So I need to create a new session variable with the new ID then use that ID on the next INSERT page and insert that ID into the database FK. Thank you all!