how to find disticnt record to bind dropdownlist??

Glad you did solved it.

Hi

You can refer the following code to solve the issue of to find disticnt record to bind dropdownlist.

SelectCommand="Select DISTINCT Featured from tbl_YourTableName"

Shailendra Verma15y ago

Dear member i have find solution ie.
SELECT MAX(ShortNameID) AS ShortNameID , ShortName FROM DailyCurrencyRate WHERE Active=1 GROUP BY ShortName

THANKS

Madhu K15y ago

If I did understand correctly distinct keyword gives you unrepeated values

select distinct ShortName,ShortNameID from tablename