vb.net DropDownList shows duplicate values

[fawadkhalil]

Hi All
I have droplistlist populated from database.When i add records everthing is ok with the dropdownlist: but when i edit records it shows duplicate values like
High
Medium
Low
Medium
how can i romove duplicate values?

[greeny_1984]

hi,

may be your dropdownlist values are concatenating with previous values.check that once.did u assign appenddataitems to true for the droddownlist.i would like to see u r code to help u more.

[fawadkhalil]

Dim dt As Data.DataTable = objlist.GetPriorityList()
Dim dr As Data.DataRow = dt.NewRow
dr.Item("PriorityID") = 0
dr.Item("Priority") = "--Select--"
dt.Rows.Add(dr)
ddlPriority.DataSource = dt
ddlPriority.DataTextField = "Priority"
ddlPriority.DataValueField = "PriorityID"
ddlPriority.DataBind()
ddlPriority.SelectedValue = 0
When i add records ddlpriority is properly populated.
But when edit sub is called it shows values like
low
medium
high
medium
excluding select.
here is code of edit subroutine
ddlPriority.SelectedItem.Text = dr("Priority")

[fawadkhalil]

one thing i forget is that values low medium high r coming from database

[greeny_1984]

HI,

Try like this.what u are doing is you are assinging the values of edited datareader values to the already selected dropdownlist.so you are getting that error.

ddlist.Items.FindByText(dr("Priority") ).Selected = true;

[srikanthkadem]

if the values coming from db having duplicates then use distinct keyword.otheerwise clear the dropdown items every time before adding like
in c#

ddlCountry.Items.Clear();

[fawadkhalil]

hi greeny_1984
ddlist.Items.FindByText(dr("Priority") ).Selected = true
gaves error "Cannot have multiple items selected in a DropDownList. "
But when i add "'ddlPriority.ClearSelection()" before urs line of code it really works.
Thank u greeny_1984 and srikathkadem

[greeny_1984]

hi,

so mark the thread as solved

[sup1991]

ddlist.Items.FindByText(dr("Priority") ).Selected = true
gaves error "Cannot have multiple items selected in a DropDownList. "
But when i add "'ddlPriority.ClearSelection()"

this really helped me a lot.
thanks