Need some help with DNN store 2.0 SQL.

Not the best at Sql and looking for help.

I need a sql statement that will update the 'store_cartitems' table (the shopping cart) with a product from the 'store_products' table directly,  where Product ID = input by user.

Any ideas?

---

www.hazeninteractive.com www.planetsocialsports.com www.rentalpropertyfind.com www.freeusedcartrader.com www.losangeles-activities.comwww.planetsportsgear.com

Can you suggest any sample code that shows how to do this?

---

www.hazeninteractive.com www.planetsocialsports.com www.rentalpropertyfind.com www.freeusedcartrader.com www.losangeles-activities.comwww.planetsportsgear.com

Hi,

Could you give more details on what you want to do? Do you modify the code?

If you modify the code, then you can use the CurrentCart class like this:

CurrentCart.AddItem(PortalId, productID, Quantity);

Look inside ProductDetails.ascx.cs the AddToCart method use this class for adding product to cart.

Gilles

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.