an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Using DotShoppingCart > Showing Products ( Summary ) based on a Query
Last Post 6/17/2009 9:31:07 PM By lukezy. 3 replies.
6/15/2009 3:49:29 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Showing Products ( Summary ) based on a Query
Hi Luke,
 
I need to show products basedon an attribute defined in product table.
 
How can I show a product summary list of all products with the same attribute :
 
 
Bahram
6/17/2009 5:21:42 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Showing Products ( Summary ) based on a Query
What attribute are you talking about, field in DSC_Product table or product attribute?
DotShoppingCart Staff
6/17/2009 10:46:36 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Showing Products ( Summary ) based on a Query
 
My Question is not about how to implement in Product table, I either use Attributes or Descriptors and use a query to get all products
for an Item.
 
I have a list of Items : ( I1, I2, I3 .... I9) and want to show them as a vertical Menu :
 
Eeach Item may be populated in several products and each product may contain 0 or more items.
 
Selecting an Item from a menu will yield to show all product related to item ( using the above query ) and display will be in current Product Summary List format.
 
So my Question Is :
 
1- Make a Vertical Menu (block) of Items
2-Make Dynamic SQL Query based on Selected item
3-Display the result set in Product Summary List format.
 
Thanks,
 
6/17/2009 9:31:07 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Showing Products ( Summary ) based on a Query
You can take a look at web\store\CategoryProductList.ascx and borrow some idea how it can be implemented.
DotShoppingCart Staff