I have been messing around with a Shopping Cart Tutorial i found on NetTuts+ I would be keen to find out how get the products from a Databse rather than use the product class they have made for the tutorial.
View 7 RepliesI am developing a website that display products and the users will be able to rate these products. At the end of the month a winner product will be highlighted on the website home page. What I need to know is how to determine the winner product if I have the following rating scenario, The user will rate for the product by choosing a value from 1 to 5 where 1 mean bad and 5 excellent.
If 10 users voted for the product A and the average rating was 4 and 1 user voted for product B and the average rating were 5 that mean product B will be the winner. I feel this is not the correct method to determine the winner. one has better method that take in consideration the number of voted users to determine the winner?
this is my last thread
[URL]
this is my code
<li><a href="Furniture.aspx?h_name=electric">Electric</a></li>
in Furniture.aspx will show all product that have H_name=electric
i have another Item
<li><a href="Furniture.aspx?h_name=?">show all</a></li>
i want when user click in this item on jquery menu in Furniture.aspx will show all product in this item H_name is'nt important i want show all product with different H_name
how to implement filters on products as this is the first time i am doing this. This is very common in ecommerce websites which sell computer products (example bestbuy.com) where a client for example would click on Monitors category, upon clicking on monitors client is presented with all the monitors available. He then could filter the monitors using filters for example he clicks on a 19 Inch monitor filter and the monitors update to only display 19 Inch monitors.
how to make this as regards tables in database?
Coming from PHP it's common to have a simple class that makes talking to a database very easy. Do people use the same approach in .net, or do you have a class for say products, which handles all database communications for the products table?
View 7 Repliesi have different tables for product details, images, category mapping
is there any way to import/export products by excel file in database along with category mappying and pictures in one go rather that importing just the products and then categorizing each product and adding image one by one ?
I'm really new at asp.net 3.5 I'm comming from Classic ASP and I have been experimenting with ASP.NET. I'm trying to use the ListView Control to display a products catalog comming from a database. My first test was succesfull but I have a question.I want to be able to display the title of the product in Bold if certain conditions exists for that product. I tried using the ItemDataBound event but I don't know how I to get the value from the database field.I have the following code
ASPX PAGE
[Code]....
CODE BEHIND
Protected Sub productsList_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ListViewItemEventArgs) Handles productsList.ItemDataBound
I am having problems in getting product data when using different levels of categories. My knowledge of SQL is also very limited.
Here is what i have so far
TABLES
Categories
CategoryID (PK) int
CategoryName nvchar(max) allow null
ParentID int allow null
Data for this table
1,Soaps,null
2,Original Range,1
3,Premium Range,1
4,Speciality Range,1
5,Seasonal Collection,4
6,Selection,4
Products
ProductID (PK) int
ProductName nvarchar(max)
ProductDescription nvarchar(max) allow null
ProductPrice money
CategoryID int
Data for this table
1,Prod1,some text,0.25,6
2,Prod2,some text,0.25,6
I have some linq to sql in the page load event that populates a list view,
[Code]....
Now when the category passed in from the query string is 6 then the products with a category of are shown correctly but category 6 is a child category of 4 and 4 is a child of 1 so when i pass in 4 as the category i should still be retrieving the data for products 1 and 2.
ProductCategory
ProductSubCategory (foreign key with ProductCategory )
Product(foreign key with ProductSubCategory,ProductCategory)
1)add/edit/delete new ProductCategory
2)add/edit/delete new ProductSubCategory (With respect to ProductCategory )
3)add/edit/delete new Product (With respect to ProductCategory and ProductSubCategory )
I dont know the best way to do this.Preferably with some vb code.
I'm trying to pull different product meta tags from a database onto a page. The problem I have is my DefaultValue="59" is the only product to be displayed if I change this value to another product id it displays just that products meta tags.
Below is my code:
[Code]....
[Code]....
[Code]....
I have recently started to use Nhibernate and i am quite happy with it until i needed to BIND to ASP.NET controls. I was having major issues binding a gridview to a collection of Products (IList). In the end i was forced to right a small routine to convert my IList to a DataTable. Once it was in datatable it worked flawlessy.
Now has come the time to bind a standard Dropdownbox to 1 field of a collection (IList) of Products but it appears i am having issues again.So this has brought me to the conclusion that i must be doing something wrong?I can't believe that it isn't possible to BIND ASP.NET controls to a collection (IList) of a class (in my case products) that is returned from NHibernate.I would really appreciate any feedback anyone has on the situation... I am at a loss
I need to display a list of products 1 below each other with a textbox, i will also need a checkbox that will hold the prodID. so i was thinking i need to do a loop but i am not sure how to do it. It needs to be like this
[checkbox(which will contain the prodID)] prodName Qty [textbox1] [textbox2]
so for each product in my products table i want to display it like above, now this is for a stock take module so the client will enter his values for each product in textbox1, when the client clicks the submit button, i will need to loop through the above products and calculate the difference if any so it will be (QTY - TEXTBOX1), if there is a difference the check the checkbox and display the difference in TEXTBOX2. so if the QTY = 10 and the client entered 8 in textbox1 then textbox2 should show you 2 and the checkbox should be checked. then the client will click the update button and it will loop through every product above and where the checkbox is checked, it should update the QTY of that product from the value entered in textbox1.
I am trying to pull all products from Amazon Product API, but as far as I know, that's impossible to do unless they give you access to Bulk Data Feeds.
View 2 RepliesI am dislplaying the products on the grid and i need to sort the items based on Price
o price: low to high
o price: high to low
I am looking for a solution (APIs, etc.) for handling a similar experience as cafepress.com. I need to be able to upload images (preferably multiple at a time) and be able to map my uploaded images to various product images (clean stock images of shirts, mugs, etc.). I also want to give the user some very basic controls over the images they upload such as cropping, resizing, levels, etc. I am looking for .NET solutions (if server-side).
View 2 RepliesI have an online shopping system and i need to compare various products How can i achieve this?
View 3 RepliesIm Searching for a tutorual to make a list of the most bought products on my e-commerce site. (toplist)
View 2 Repliesi have a product page that can potentially take in the following optional query string params:
Category, OrderBy, Page
How do I create my route so the urls show up like this:
Products/Category/Electronics
Products/Category/Electronics/OrderBy/Price
Products/Category/Electronics/OrderBy/Price/Page/1
basically, im trying to not use the ? for my query string params.
I just passed my view a list of products for the last 90 days sorted by date and need to display it in an efficient way that will group the products by date.Linq-To-Sql doesn't understand a lot of the date comparison functions,so I'm kinda lost as to what to do here.What I would like to do is contain each group of products with the same date inside of a div with a title like "Today", "Yesterday" or "Last 30 Days".
View 1 Replies the best way to achieve the following:A products table linked to an images table where 1 product can have many images.Simple scenario is to select a product and its images using
select * from products where id=5
select * from images where pid =5
So far so good, its easily mapped to an object once the query has executed with ado.net.
what if i want to select all products and their related images and map them to a Product object, the result is as follows
SELECT * FROM PRODUCTS JOIN IMAGES ON ID=PID
Now the table I get is:
ID PRODUCTNAME IMAGEURL
1 COMPUTER IMAGE1.JPG
2 COMPUTER IMAGE2.JPG
3 COMPUTER IMAGE3.JPG
I would need to do some work in c# to keep track of id and get images until the id changes, if you get what I mean.
I want a way that I can execute a single query like the one above, or modifed version and make it easier to map the result to my objects.
Something like,loop products,map products to product object,loop images map images to products.images
I want to find the keywords/products in text block and link them to my products.
Is a algorithm or sample code somewhere i can start with?
I have a gridview which shows products from product table. I have 1000s of products in db and gridview shows 15 records per page. I want to fetch only 15 records from database at one time but page number should show as all products are in list and with page change next products should be displayed. grid has sorting enabled. on top of page there is a text box for records filtering so I need to keep sorting in mind as well.
View 1 RepliesI'm sending automatically emails when customers buy products on my ecommerce portal.
But, send pages by emails, at least in my server, using asp.net is too slow.
So, I want to send emails automattically, but using SERVER PROCESSING (Server Side). Did you get my point?
The customer won't see the sending process. But in background, directly on the server, the email is being sending.
I am only start learning MVC 2.I have class
[Code].... I wrote HttpPost in controller
[Code]....
my page has next code:
[Code]....
Why InvoiceFinalViewModel view, List<Product> products parameters came with null and zero value in post ?
How correct bind arrays in MVC ?
Im haveing three tables T1 ,T2, T3. T1 contain root node for tree view, T2 contain child node and T3 contain product.Im populating the tree view from T1 and T2. Now I want count of products in each subcategory in front of each child node(T2). The products are being uploaded by user.Plz help how to achive this.The code to populate the tree view :
if (!IsPostBack)
{
//Fill the treeview control Root Nodes From Parent Table
[code]...