How to set up dropdownlist selected value

[Guest]

Hi, I have a dropdownlist that is basically pulled the data from database
using sqldatasource.

The dropdownlist will give years result. The results will be from 1967 to
2006.

I have anoher query using sqldatasource that will give me the result of year
2004. How do I bind the second query so the dropdownlist will make 2004 as
its default selected value? RIght now, 1967 is by default the selected value.

Thanks.

 

[Karl Seguin [MVP]]

years.SelectedIndex = years.Items.IndexOf(years.Items.FindByValue("2004"))

you can also do FindByText(...)

Karl

 

[Teemu Keiski]

Hi,

get the value from the second query into a string variable. Then you can
just make the selection:

DropDownList1.SelectedIndex =
DropDownList1.Items.IndexOf(DropDownList1.Items.FindByValue(<string_var_goes_here_with_value_2004>))

Yes, you can also do it in code.