Apologies if this has been posted several times before however i cannot find this within the search.

Here is my scenario:
 
For each product in my ecommerce website i need to dynamically create dropdown and populate them for each product dependant on the attributes assigned to them.

e,g

Colour
Size
etc etc

Some product will not have any, and some product will have more than two options. I have succesfully created the database structure i believe i need, i just need help creating the dropdown control dependant on the number of attributes (colour,size) assigned to the product.

Can anyone help ?

 

create a dataview ordered on colour and size it will do the trick

what you do is get a dataset of all the items in the db that match the part, then use a dataview to order them correctly.

my 2 cents

apologies i am guessing i didnt explain correctly.

I can happily populate a dropdown with data from the database however i need to create the dropdown control dynamically i.e some products will have 2-3 dropdowns, some product could have 1-2 dropdowns containing the values of the attribute (whatever that attribute may be)

Hope this helps
 

create teh control at runtime based on values

iterate your data if it has attributes you load the control....ddlist

 Me.Controls.Add(Me.LoadControl(Virtual))

Perhaps this will be of some help:

http://www.asp.net/learn/ajax-videos/video-77.aspx

Create a Runtime control like

dropdownlist  ddl  = new dropdownlist();

ddl.datasource = Ds ( your dataset or Data reader)

ddl.Datatextfield ="xxx" (your attribute to display to  user)

ddl.datavaluefield  = "yyy" ( value shoud pass to server)

me.controls.add(me.loadControl(ddl));

I hope this will help you.

if it helps this guy explains better: http://forums.asp.net/p/346743/346743.aspx     in a previous post.

 Thanks