<div>
<div class="content wysiwyg-content">
Hi<br />
I have an ASP.net 4 project with one table and a TableAdapter shown in the image below.<br />
I have several dropdown boxes on my WebForm: one for each column in the table.<br />
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.<br />
Thanks <a href="https://filedb.experts-exchange.com/incoming/2011/03_w12/434545/image.jpg" target="_blank" title="DataSet1 (118 KB)"><img alt="DataSet1" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2011/03_w12/800_434545/image.jpg" /></a>
</div>
</div>


image.jpg

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 

ASP.net use DataSet TableAdapter to populate dropdowns

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.