Remove duplicate values from dropdownlist ?

Question

Hi When user selects a row in gridview i need to display the selected value in the dropdownlist.. The dropdownlits are populated at page load event... the selected value is getting displayed along with the value in the database.. How do get rid of duplicates?

Danish Habib · Answer

appenddatabounditems to false should solve the issue

Vikram Agrawal · Answer

Hi Suchitra You can use DataView for get rid of duplicates. DataView will filter records based on given condition

Karthik Agarwal · Answer

In order to avoid duplicates just create a list and populate the list with the elements with which your dropdown will be loaded. While loading the list just ensure that whether you have that element in the list or not. This way you can avoid duplicates. You can do that using following syntax. Dim list As New List(Of String) If list.Contains(string) Then //don't do anything Else list.Add(element) End If

B M Suchitra · Answer

@Datta I have already explained it in my question but still for your understanding: When user selects a row in gridview i need to display the selected value in the dropdownlist.. The dropdownlits are populated at page load event... the selected value is getting displayed along with the value in the database.. How do get rid of duplicates?

Datta Kharad · Answer

@Suchitra Can you attach your example? or Describe your problem in detail...because I don't know exact problem which is facing you.

Abdullah Munshi · Answer

You need to use DropdownList .SelectedValue insted of SelectedItem it will solve your problem. on GridviewSelectedIndexChanged event you can try something like DropdownList1.SelectedValue=Gridview1.SelectedRow.Cells[0].Text;

B M Suchitra · Answer

Hello Mr Datta Same method i had got after i googled but that did not work for me so i came here and posted

Datta Kharad · Answer

Hi You can use below method to remove duplicate values from dropdownlist. 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; } } } }