select item from dropdownlist where value = key 1

[cjburkha]

Hi all, I have a dropdownlist that I populate like this

                eventDL.DataSource = sqlSelect("Select * from [event]")
                eventDL.DataTextField = "eventName"
                eventDL.DataValueField = "pk_Event"

My problem is I want to set the selected index based on the string value of the dropdownlist, but I am using value to store the index.

I made a loop

                eventDL.DataSource = sqlSelect("Select * from [event]")
                eventDL.DataTextField = "eventName"
                eventDL.DataValueField = "pk_Event"

But I think there should be a more efficent way. Any ideas?

Sorry if this is the most repeated question, but I see a lot of people using value to store the display string, but I am using value to store the primary key of my DB so I don't have to lookup again.

Thanks again

CJB

 

[jbenson001]

It is unclear to me what exactly you want to do. YOu have a dropdownlist, Value field is the index, good, the text field is something else, good.. Now, please describe what you want to do once it it is populated.

 

[cjburkha]

Jeez I'm a dolt.

I want to make the following code more efficient:

                i = 0
                For Each Item As ListItem In eventDL.Items
                    If Item.Text = "asdf" Then
                        eventDL.SelectedIndex = i
                    End If
                    i += 1
                Next

I would like to set the selected text to something I want

 

[jbenson001]

Try this, I use it all the time:

eventDL.Items.FindByText("asdf").Selected = True

 

[cjburkha]

Thanks, thats exactly what I was looking for.

I knew there was a built in method for what I was trying to do, I just couldn't find it.

 

[jbenson001]

Not a problem, glad i could help..
Jim