E-commerce ASP net - query SQL between 2 tables

Question

1.00/5 (1 vote)

See more:

Hi to all, i ' m developing a E-Commerce web site, but i have problem with this : how can i bring parameters between tables of my db ?
Let me explain better, i have a page where you click buy an item, and then add it to Shopping cart (another db table) , but unitl now i pass only the id through navigation url and take it in page load with request.querystring.
How can i complete the table Shopping Cart with Name of the Item, Price and Quantity ?

Thank you so much.

What I have tried:

[removed]

Posted 29-Mar-17 22:10pm

EmanuelPirovano

Updated 29-Mar-17 22:38pm

F-ES Sitecore

v2

Add a Solution

Comments

EmanuelPirovano 30-Mar-17 11:44am

Thank you man.

I' ve find another way : INSERT INTO TABLEX(ID,NAME...) SELECT ID,NAME... FROM TABLEY

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

F-ES Sitecore · Answer 1 · 2017-03-29T22:38:00

Normally you would only store the ID and whenever you wanted to show the basked you would JOIN your Basket table on your Product table on the ID, effectively creating a virtual table that has all the fields from both tables, so you can now access the product name etc

SELECT * FROM Basket B JOIN Product P on B.ProductID = P.ID

However for a basket you might want to copy things like the price across into your Basket table. So when it is added to the basket store the product ID but also store the price. The reason for doing this is in case the price changes. If it was "£10" when I added it to my basket and the price changes it should still be listed as "£10" in my basket as you are making a contract with the customer when they add something to their basket that they are buying that item at that price.

So to show your basket you would still do the join, but the product name, description etc would come from the product table (P.Name, P.Description in the above query) but you would get the price from the basket table (B.Price).