stored procedure

Question

hi, i am creating a order page which selects the customer's order and stores in database but i also want the product id to be stored in database how should i do it? And the product id should be selected from session i.e. i have taken it as session[dealid]=id.


Can anybody solve  my problem....
Thanks.....