Solved

ASP.net use DataSet TableAdapter to populate dropdowns

Posted on 2011-03-19
2
366 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:murbro
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
AkAlan earned 500 total points
ID: 35172611
SELECT DISTINCT ColumnName FROM YourTable
0
 

Author Closing Comment

by:murbro
ID: 35187207
thanks
0

Featured Post

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
asp web application 3 40
sql 2016 data tools breakdown.. 1 26
YouTube API get the Video Tags - vb.net 7 30
T-SQL: I need to add an index on a field 5 25
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question