set default value in dynamic drop down

[Garima12]

There is dropdown on webpage and I m filling it dynamically at run time. I want to set an item as selecteditem. that item will be decided on the page load based upon value I got from databse.
I set DataTextField,DataValueField properties of dropdown.
Initially I got data printed on label and set dropdown.selectedvalue=label1.text
it was working fine before setting DataValueField.
after setting DataValueField,it is throwing error "item you are trying to set as selecteditem is not in the list."
Please tell me some solution.

[malav123]

Hi garima,
I am not getting exactly what is problem in your application.... so please tell me the problem clearly...

[Plater]

Set the SelectedIndex to a value?

[balabaster]

Set the SelectedIndex to a value?

Plater, I don't think she's asking quite what you think. In the database, she's storing the selected value which you can't set at runtime, only read. So we have to find the index from the value.

Dim MyValue As Integer = OledbDataReader1("StoredValue")
MyDropList.SelectedIndex = MyDropList.IndexOf(MyDropList.FindByValue(MyValue) )

[Plater]

You just described in much better depth what I was trying to get out.
Sometimes work eats my brain.

[balabaster]

You just described in much better depth what I was trying to get out.
Sometimes work eats my brain.

It's odd...I'm at work, stuck in meetings...and I spend more time answering questions on here so that the incessant roundabout conversations don't eat my brain.