I would like a dropdown list to load with all values in a database table, which is no problem. But, I would then like it to display a selected text value from that list, depending on the value returned by a SQL query. As an example, say I was looking-up someone's personal data and there was a dropdown list that listed all the possible hair colors. If this person had been entered as having blonde hair, I want the dropdown list to display blonde at page load, but give the user the option to select another color if a change is needed. Is this possible?

KO

Set the "SelectedValue" property on page load. This example uses a dataset to hold the SQL query:

ddlName.SelectedValue = dsDataSetName.Tables("tblName").Rows(0).Item("Item ToBeSelected")

Modify this according to your code.

J

Add on to previous message:

Note that the value in the dropdown list will have to be equal to the database value...

J

Yes, I want the value that is displayed to be one of the values already stored in the database table I am querying. I just don't necessarily want it to be the first value.

KO

I guess the easiest way to say it is that, normally, the default text that is displayed at page load by a dropdown list is whatever is stored at index 0. I want to be able to select any item from the list to display as the default, so that my selection is the first thing the user sees when the page loads.

KO

How exactly are you using this? Are you using it as an update page?
If so, my suggestion should work for you. It is one of the methods that I use.

J