Insert data into two tables and retrieve last ID

I have a form that has a checkbox list.  The form gets submitted and the checkbox list is saved into an array list.  I want to save the main form data to one table and then save the ID created to the linking table with each item checked in the checkbox list.  

I want to use a stored procedure to do this, so how do I get the ID that was just inserted and how can I pass the list of checkbox values that I stored in the array list?
monica73174Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
if the field is identity, the query to get the last inserted id (within the same session) is
SELECT SCOPE_IDENTITY()

with sql 2005, you have also the possiblity to get the id values when inserting multiple rows at once, using the OUTPUT clause...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
monica73174Author Commented:
I think that solves my first problem.  Now I need to know how to pass an array to a stored proc and insert the values into a linking table with the ID.
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
monica73174Author Commented:
Thank you, your answers were very helpful
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.