ASP.net use DataSet TableAdapter to populate dropdowns

Hi
I have an ASP.net 4 project with one table and a TableAdapter shown in the image below.
I have several dropdown boxes on my WebForm: one for each column in the table.
Using the DataSet I want to populate each dropdown with the unique items from its corresponding SQL column. How do I go about this for one of the columns.
Thanks DataSet1
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
AkAlanConnect With a Mentor Commented:
SELECT DISTINCT ColumnName FROM YourTable
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
thanks
0
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.