display info from database

[abexander]

hi everybody, currently im developing a website for my final project and im a beginner for asp.net.
I want to display information from database to my dropdownlist page on page load.it works but i want to dislay only distinct information from the columns of the table how can i do that?my databse is sqlserver
please help.
thank you in advance.

[postmaster]

There are two examples at :

http://www.programmingknowledge.com/dataControl.aspx

http://www.programmingknowledge.com/simpleDataGrid.aspx

[Tim Cook]

SELECT DISTINCT ..... then whatever else you want in

[abexander]

SELECT DISTINCT ..... then whatever else you want in

I HAVE TRIED BUT NOT WORKING.IT DIPLAYS ALL THE REDUNDANCIES TO THE DROPDOWNLIST.bUT I WANT ONLY THE DISTINCT.
PLEASE IF YOU KNOW HELP ME MORE.