Wrox Programmer Forums
|
BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6
This is the forum to discuss the Wrox book ASP.NET 2.0 Instant Results by Imar Spaanjaars, Paul Wilton, Shawn Livermore; ISBN: 9780471749516
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 6th, 2010, 08:04 AM
Friend of Wrox
 
Join Date: Oct 2009
Posts: 341
Thanks: 14
Thanked 3 Times in 3 Posts
Smile Multiple values for product in web shop

Hello Imar,
Web shop is working fine till now and no problem is there. But I wanna show products like Shoes, Garments etc. which have a field Size and as you know that these types of products may contain multiple size and hence Price too (Price varies as size varies). In spite of showing different product for different size I want to show single product with multiple size values and when user go to shoppingcart.aspx page then he may select the size also and hence corresponding price is selected for the product.

So how would you suggest to store multiple size, price values for a single product and then manipulate the Total Price?
Thanks
 
Old October 6th, 2010, 09:22 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

This is a bit too extensive / complex to discuss in detail over a forum post. But I would probably create an additional database table called Variants that stores information that different for each variant (such as size, price and so on) and that has a reference to a Product. Then each Product gets a Variants collection that holds the different variants for the specific product.

Hope this helps,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
 
Old October 13th, 2011, 02:13 AM
Friend of Wrox
 
Join Date: Oct 2009
Posts: 341
Thanks: 14
Thanked 3 Times in 3 Posts
Smile

Hi Imar,
Again coming back to topic. It seemed a little complex and beyond my approach so I left it that time.
But now I want to complete it. According your solution I would need to create a table say Variants with 4 fields Id, ProductId, Size, Price.
Then I need to enter different values for product that needs such variants. Right?

I will go on and hope you will suggest in time.
Thanks...
 
Old October 13th, 2011, 02:14 AM
Friend of Wrox
 
Join Date: Oct 2009
Posts: 341
Thanks: 14
Thanked 3 Times in 3 Posts
Smile

Hi Imar,
After a year again coming back to topic. It seemed a little complex and beyond my approach so I left it that time.
But now I want to complete it. According your solution I would need to create a table say Variants with 4 fields Id, ProductId, Size, Price.
Then I need to enter different values for product that needs such variants. Right?

I will go on and hope you will suggest in time.
Thanks...

-----------------------------------------------------

P.S. Please delete one of the two posts that I recently posted.

Last edited by sophia; October 13th, 2011 at 02:17 AM.. Reason: Duplicate posts
 
Old October 13th, 2011, 02:39 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Yes, that's indeed how I would approach it,....

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
 
Old October 13th, 2011, 12:11 PM
Friend of Wrox
 
Join Date: Oct 2009
Posts: 341
Thanks: 14
Thanked 3 Times in 3 Posts
Smile

Thanks for reply. As soon as I complete it, I will mention it here.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Web Shop - Why do redirect to Login page? nhvubak BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 2 August 3rd, 2010 05:04 AM
Multiple category for a product. ashwinirajp BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 4 November 13th, 2009 08:24 AM
emailig in web shop sophia BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 17 October 20th, 2009 09:58 AM
Web Shop TB1962 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 3 January 26th, 2009 05:24 AM
atlas and web shop gtjr92 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 1 October 21st, 2006 03:38 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.