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.

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

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.