This is going to be a bit lengthy:( Kindly read it to the end.
I have a page to add products. When the user adds product, he/she is asked to add the specifications . I have all the attributes for a particular category say `Mobiles` like Camera,OS,Type etc etc. All the attributes are divided into groups(See Table Below). If the user is uploading a product in `Mobiles` category , I want to select all the groups ith the category and then the attributes in the Group and display it on the UI. Kindly go through the steps to understand the scenario. Table (CategoryGroups)http://i.stack.imgur.com/D20o3.png
]Step 1 :
Select all the groups from a particular `NodeID`Table (GroupAttributes) :http://i.stack.imgur.com/qNHFW.png
]Step 2 :
Display all the Attributes to the user Grouped By `GroupName` i.e `AttributeID` 1 & 2 should come under `Group 1` , `AttributeID` 3 & 4 should come under `Group 2`Step 3 :
For each row check if `canSelectMultiple` is `True` or `False` . Step 4 :
If `canSelectMultiple` is `False` Add `DropDownList` to the page and add each Value in `Value` column to the `DropDownList`[**Value column has semi colon separated values**] i.e for the 1st row Add `DropDownList` with Values "Android","Bada","Blackberry",Symbian,"iOS"
ElseIf `canSelectMultiple` is `True` the Add `CheckBoxes` to the page with one `CheckBox` for every value in `Value` Column.Step 5 :
Save the values selected by the user in DB on Button Click.