how to merge same values when binding the dropdownlist?

Question

how to merge same values when binding the dropdownlist? when i bind the dropdownlist as a result i get 2 same values (like 45 45 24 24) but i only want (4524 ).

Sanjeeb Lenka · Answer

hi try this code public static void RemoveDuplicateItems(DropDownList ddl) { for (int i = 0; i { ddl.SelectedIndex = i; string str = ddl.SelectedItem.ToString(); for (int counter = i + 1; counter { ddl.SelectedIndex = counter; string compareStr = ddl.SelectedItem.ToString(); if (str == compareStr) { ddl.Items.RemoveAt(counter); counter = counter - 1; } } } } call this method by passing the dropdownlist id. ex- RemoveDuplicateItems(ddlemp);

Iftikar Hussain · Answer

Hi Can you please provide your code? If you are binding from sql query then you can use Select distinct col1col1 from table1 Regards Iftikar