C# Dropdown list in sql table?

The C# web application has to pull a couple of drop down list in a form that will be cascade filter. For example depending on selection 1 in the dropdown list 1 the drop down list 2 will be populated.

What is the best way to populate the 2 dropdownlists. in the form. Not sure if i have the data in teh table form in sql tables.
Who is Participating?
iHadiConnect With a Mentor Commented:
Webservices are very easy to build and use. They are even easier than web pages to build. They do not need to be in a separate project. You can add a webservice asmx file as easily as adding an aspx file.

After you add it, all you need is to write your method in it and decorate it with the some attributes. That's it.

If you need help with that, just post here.
I suggest you do it using ajax. You can use the ajax Control Toolkit to do so:


or any other Ajax library like jQuery
XPLRAuthor Commented:
The example is exactly what i needed but it uses webservices and i was hoping to do with something easier..
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

XPLRAuthor Commented:
Can you give me an example of webservice method? I know how to create a webservice add file.
Also should you still use sql datasource or object data source?
XPLRAuthor Commented:
http://www.asp.net/ajax/ajaxcontroltoolkit/Samples/Walkthrough/CCDWithDB.aspx -This example is complicated and i am new to .net/ajax coding. Also we are using a third party (telerik) for cascading drop down control. I'de appreciate if you can give a simple example
XPLRAuthor Commented:
Looks like a complex solution
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.