I'm looking to dynamically control a set of drop downs so that they'll filter their items after another drop down's index has been changed.
I'm working in C#/ASP.net and it would be great if I could get the necessary data straight from Sql Server. I suppose I could generate an xml file whenever new data is uploaded to the server but that sounds like a pain.
Is there an obvious way to do what I need to do?