hi all

i am having a problem in my sqlserver part, where i need your valuable advices.

i have some informations to be saved to a table(Order.dbo) on a button click.
problem is that these values have to be got from different parts.

fields
1) UserID -- this is now stored in a session variable session("UserID")

2) OrderDate -- todays date
3)ProductID --- from a table called ShoppingCart
4)ShippingCost --- in a label (lblship.text)
5) tax -- in a label
6) total -- in a label.

i know i am confusing you all.
but i dont find any other way to express my problem

is there any way to do this?
please help me to solve this.

thanks

so combine them all into a single insert statement??? Not sure I follow the question.