DropDownList Populated from Database 2

[dmears1]

I'm populating a dropdownlist control from data in a database. This is working correctly. However, I'd like to add a list item for "Select Alll" as index 0. Is there a way to manually add list items even if you are using databinding? Any help is appreciated.

http://www.Morter.com

http://www.BestLifeTraining.com

http://www.AbsoluteStudio.com

 

[ca8msm]

Yes, one method would be to actually add it to the data source itself (i.e. in the SQL). Alternatively, add a row to the DataTable (or whatever data control you are using) before binding.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[jbenson001]

DropDownList1.Items.Insert(0, "Select All")

 

[dmears1]

Thanks guys for the help. Got me pointed in the right direction. Here's what I came up with:

ddlCity.DataSource = SqlDataSourceJobs
            SqlDataSourceJobs.SelectCommand = "SELECT DISTINCT jobCity FROM jobs"
            ddlCity.DataBind()
            ddlCity.Items.Insert(0, "")
            ddlCity.Items.Insert(1, New ListItem("All", "*"))
            ddlCity.SelectedIndex = 0

Thanks again for the help.

http://www.Morter.com

http://www.BestLifeTraining.com

http://www.AbsoluteStudio.com