I have one table in a de-normalized form Named 'Category Classification' in which i have 4 fields like Category, Subcategory, Brand and Company. I want to develop a searching criteria on asp.net in which the scenario would be: * If i select category from the drop down, It should automatically show the subcategories associated with that selected category in the next drop down of the subcategory. *Same goes for the brand as well. If i select the subcategory, The grid should appear with the check boxes of the related brands of that selected subcategory.
The screen shot of the said criteria is attached along.
I need the logic behind the denormalized database like Microsoft excel has that functionality which i need to implement on asp.net.
Your help would be highly appreciated.