hi all,

i am trying to develop a sample ecommerce aplication, in which i want your help in proceeding.

i am displaying shoping cart items in a datagrid, below the datagrid, i am displaying subtotal, tax, shippingcost,grand total like fields in lablels.

once the user finalises the items, and click to confirm order, i want the informations to be saved to an Order table.

how can i do that? using stored procedures?

can anyone please help me
thanks

Isnt your cart already stored in a backend table?

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

yes, but the cart table has only productid, unitprice,quantity etc.
it is not containing subtotal, grand total(after tax and all)

You can still figure the information out in SQL. You have the quantites and the product prices and you have hard coded your tax rate so moving the data from the cart to the order table would be no different. Just do all of the addition and such in a stored procedure and it should work fine.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

how can i assign the values in datagrid, as the parametrs of stored procedure.
is there any way to do that?
i am displaying productid, unitprice,quantity in datagrid, these values, how can i take into stored procedure?

No, not easily anyway. Since you will have a dynamic amount of items/quantities/prices in the datagrid it would be hard to write a stored procedure that could handle this. What you might end up doing is looping through your datagrid like this:

for each row in datagrid
get productid, unitprice,quantity for this row
populate a stored procedure
execute stored procedure
loop

So you write a stored procedure to handle just one item at a time but loop through each item in the grid.

I dont think that is very effecient and would probably choose to do it a different way but I do not know your infastructure so can't advise any other way.


-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

yes Mr.Parson, i also think that, i am complicating the matter.
i will try the way you suggested.ie, with the sql