Solved

ASP.net use DataSet TableAdapter to populate dropdowns

Posted on 2011-03-19
2
365 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
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

777 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