how to get the distinct value in a dropdownList in c#.net

i am using c#,SqlServer,LLBLGenPro. Plz reply as soon as possible.

Create a dynamic list, please see the documentation on typed lists/views in the using the generated code /adapter/selfservicing section, which contains an example about how to create dynamic lists.

for drop down lists, you basicly create a ResultsetFields object of 2 fields (name and value) and when fetching it, specify false for 'allowDuplicates' in either GetMultiAsDataTable() (selfservicing) or FetchTypedList (adapter). As you haven't specified what you use (selfservicing or adapter) I can't provide you with an example.

Also please see: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=1522