Remove duplicate values from dropdownlist ?

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

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

@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?

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

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;

Hello Mr Datta,

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

Hi
   You can use below method to remove duplicate values from dropdownlist.
   void RemoveDuplicateItems(DropDownList ddl)
{
for (int i = 0; i < ddl.Items.Count; i++)
{
ddl.SelectedIndex = i;
string str = ddl.SelectedItem.ToString();
for (int counter = i + 1; counter < ddl.Items.Count; counter++)
{
ddl.SelectedIndex = counter;
string compareStr = ddl.SelectedItem.ToString();
if (str == compareStr)
{
ddl.Items.RemoveAt(counter);
counter = counter - 1;
}
}
}
}