I have a dropdown list which is taking information from a database
in which i used as per below
SELECT DISTINCT * FROM [Devices]
but still it shows multiple same values.I want that the values are unique.How should I fix it ?
I already clicked -return only unique raws- under the sql databaseconnection settings still have multiple same values :(
is there any other easy way for this ?in case that I don't want to create too much accessdatasources for this bindings.
I'm not sure what you mean. I assume that what you are working with is a dropdownlist control and you want to populate it dynamically? If that is correct, yes you have to connect this control to a data source just like you did.