palmtreeinfotech
asked on
Use New Inserted Autonumber ID as session variable
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.