hi all

i am displaying some add to cart information in a datagrid, how can i store those values into a temporary table, so that, if the user deletes a particular order he just selected, the information get deleted from the temporary table, not from the databse?

thanks in advance

Use the temp table as your cart (as opposed to storing the information in session), each cart has an id, then, if a user removes an item, DELETE from tmpTable where cartID = [value]

"The one language all programmers understand is profanity."

hi

thanks for your reply
what is your opinion? to use a temporary table or to store information in session?
which one is the best approach?

"Best" is a subjective term because it all depends on your needs/wants. Storing information in Session will be slightly faster because there is not the overhead in opening a database connection, retrieving data, displaying it, etc.

Using session though, if a users session times out, they will lose their entire "Shopping Cart" and have to start over where as a database shopping cart can be persisted over multiple Sessions. Which you choose to do will depend, as I said, on your needs and wants.

"The one language all programmers understand is profanity."