|
Hello,
I'm learning ASP.NET 2.0 in order to build an e-commerce website.
I'm confused as to how product attributes in an online store are handled in the SQL database; I have been poring over a number of ASP.NET 2.0 books in search of an answer, but to no avail.
For example, this link to a shoe on the LLbean website (http://tinyurl.com/y6cs4l) shows three pull-down menus on the right column, under "Step 2: Select Options": Width, Shoe Size, and Color/Style. Each pull-down menu contains a number of product attributes, so that the customer can order a shoe in "Medium D, Size 9, Ash Bark" or some other color and size combo. Up one level, on the page that displays all the hiking shoes in this product group (http://tinyurl.com/y8hw59), these options don't appear. Each shoe appears only once as a thumbnail image, and the color and size options only appear when teh product detail page for each shoe is opened.
I am building a similar sort of product database, containing many items that have multiple sizes, colors, and attributes. Each product size and color variation has its own SKU (product code #). However, this means that on my product display pages, each size and color option for a product appears seperately, which clutteres the page and looks unprofessional. That is, one will see thumbnails of a certain product appear in size 7, size 8, size 9, etc., instead of just appearing once with the attributes accessable only on the product detail page, collapsed into the pull-down
menus.
I am not sure how to structure the database to achieve this, and would be grateful for any suggestions. My SQL database now has columns for size and color, but this means that each color and size option has its own row in the database, and its own SKU.
Please forgive the long post, I wanted to explain clearly...
Thank you!
|
|
|
|
|
Product Table
ID - Name - Description - Image - etc...
1 - Shoe - Nice, Sensible, comfortable - etc...
SKUTable
ID - ProductID - Description
1 - 1 - Medium D, Size 9
2 - 1 - Large E, Size 12
List SKUs - Select * from SKUTable where ProductID = 1
only two letters away from being an asset
|
|
|
|
|
Aha - so the SKUs are broken out into a seperate table - outstanding. This is an enormous help, I think you have solved my problem.
Thanks very much!
|
|
|
|
|
A project of this magnatude may be above beginner level if this is going to be in production.
|
|
|
|
|
You are probably correct, but fortunately 90% of the structure has already been built, and I am renovating it and adding data. One thing the previous builders did not do was break out SKUs onto a new table, as above.
Thanks.
|
|
|
|
|
Hi,
I have a question related to the body onload event. In the absence of Atlas this event is fired everytime the page refreshes. I have code in the onload event that needs to execute everytime there is even a small change to the client. When using onload with Atlas, I find that it fires the first time the page loads, but not everytime the page refreshes. Which other event can I use to execute code everytime there is even a small change to the page?
Thanks.
-Shefali
|
|
|
|
|
hi all,
what is the difference b/w Usercontrols & masterpages (dotnet 2.0 new control)?
Thanks,
Rahi
If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
|
thanks for the response. actually i know the concepts. but i didn't understand why microsoft introduced these master pages over Usercontrols?. we can achieve the master pages concept using usercontrols (as per my knowledge. sorry if i am worng)
If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Re-read the documents. They are different technologies serving different purposes.
Master pages provide functionality that developers have traditionally created by copying existing code, text, and control elements repeatedly; using framesets; using include files for common elements; using ASP.NET user controls; and so on. Advantages of master pages include the following:...
only two letters away from being an asset
|
|
|
|
|
They are 2 completely different paradigms. Check the documents again.
|
|
|
|
|
hi, i upload the asp project on my ftp and when i am going to the url where the query.aspx its telling me:
Runtime Error <br />
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. <br />
<br />
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".<br />
The problem is that i made the mode to off but nothing happens. all the time this error occurs  .. why is this?
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
|
|
|
|
|
You may have installed your application without the proper directory structure. Thus it cannot find its web.config.
|
|
|
|
|
I want to be able to add a link to a dataview (eg More Info..) which will open a pdf that is saved in a subdirectory of the site (eg uploaded_files). the file is identified by taking the ID field number and using that as the name (eg id+.pdf). I need to be able to program this but it is beyond me. of course a problem is that the filename differs according to which view you click. a tutorial or similar would be welcome as well!
cheers
nick neutron
|
|
|
|
|
hi Guys,
I am having LDAP troubles Im trying to connect to AD by using the code below, but I get error messages saying the "server is not operational" !!!!
DirectoryEntry entryAgent = new DirectoryEntry("LDAP://localhost:636/", "username", "pswrd", AuthenticationTypes.SecureSocketsLayer | AuthenticationTypes.Secure); <br />
<br />
DirectorySearcher searchAgent = new DirectorySearcher(entryAgent);<br />
<br />
searchAgent.Filter = "(objectClass=*)";<br />
<br />
foreach (SearchResult result in searchAgent.FindAll())<br />
{<br />
Response.Write(result.GetDirectoryEntry().Name.ToString());<br />
}
Can anyone tell me what is it that Im not doing right?? Thanks in advance!!
Nila
"...for that, I will need a large cup of coffee and a brand muffin!" -Samantha Bea
|
|
|
|
|
I'm creating some crystal reports in visual studion .net but for some strange reason, some of the reports are not reflecting the changes I've made to my stored procedure query.
For example, if I switch my query from "SELECT id, name FROM table1" to "SELECT TOP 1 ID, name FROM table1", this change is not reflected in the report. Instead, the report continues to return the 1000 rows it always did instead of only the top row. Some of my other reports however, DO reflect this change.
I've tried re-verifying my database and even deleting the entire reference to my stored proc and then reconnecting but so far, have had no luck. So I'm a little perplexed right now.
Any ideas as to why this may be happening and what I can do to aleviate something like this?
Thanks.
-Goalie35
|
|
|
|
|
Sir,
My question is based on ensapsulation.I know the encapsulation(hiding the background details from the user).
Now my question is when the website is uploaded .In the aspx page we can view only the html code .I mean vb file or .cs don't appear online.If we can't view the vb file or .cs file then what makes the encaplulation means .
Thanks
|
|
|
|
|
I think you're confusing the role of the "user" here. The user would be the programmer that is using that class, not the end user.
|
|
|
|
|
The "user" can also be another class. If class A is using class B, it only needs to know enough to use the class B, not everything that the class B contains.
---
b { font-weight: normal; }
|
|
|
|
|
I didnt want to confuse him. He seemed lost already 
|
|
|
|
|
I have sql server database and the user will key some data from databse.
After that, i want to transfer this data to a PDF form.
How can i do that?
|
|
|
|
|
Check here:
http://www.codeproject.com/cs/samples/CreatePDF.asp
|
|
|
|
|
|
Hi Thanks for reply but
i dont wants to generate pdf from crsytal reports.
I already have pdf form file and wants to write into it.
i dont know the fields name and i wants to write it . is there any way to write in a pdf form,and you dont know the name of the form fields????
|
|
|
|
|
I am creating a setup project for my project which am deploying together with an sqlserver database using SQLEXPRESS. During the installation a custom action attaches the database to the SQLEXPRESS instance. The installation is smooth in most cases, but it fails in some instances when the instance is NOT set to log on as a Local System account. Could someone help me with some code (or just insights) to programmatically check whether SQLEXPRESS on the deployment machine logs on as a local system account, and if not configure it to log on as local system account?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
