[RESOLVED] Drop down list option disappears

Webskater · Jul 5th, 2007, 04:02 PM

If I write ...

Code:

<asp:ListItem Value="0">--Select Category --</asp:ListItem>

... it creates an <option> in a <select> drop-down list.

To populate the drop-down list I am doing something like this to get the list items from a database:

Code:

                conn.Open()
                reader = categoryComm.ExecuteReader()
                categoryList.DataSource = reader
                categoryList.DataValueField = "CategoryID"
                categoryList.DataTextField = "Category"
                categoryList.DataBind()
                reader.Close()

... which works fine. But, when I populate the list from the database it deletes the <asp:ListItem> so it no longer says --Select Category-- at the top of the list. The list only contains the items from the database.

How can I get the --Select Category-- option to stay there?

Thanks for any help.

techgnome · Jul 5th, 2007, 04:15 PM

It has to be a part of the list that is returned by the data source.

-tg

Webskater · Jul 5th, 2007, 05:54 PM

Thanks for your reply. But, hoping it wasn't true, I have been ferreting around and found that if you set AppendDataBoundItems to true - you can put your 'heading' category at the top and the data bound items appear beneath.

Jul 5th, 2007, 04:02 PM	#1
Webskater Hyperactive Member Join Date: Nov 06 Posts: 420	[RESOLVED] Drop down list option disappears If I write ... Code: <asp:ListItem Value="0">--Select Category --</asp:ListItem> ... it creates an <option> in a <select> drop-down list. To populate the drop-down list I am doing something like this to get the list items from a database: Code: conn.Open() reader = categoryComm.ExecuteReader() categoryList.DataSource = reader categoryList.DataValueField = "CategoryID" categoryList.DataTextField = "Category" categoryList.DataBind() reader.Close() ... which works fine. But, when I populate the list from the database it deletes the <asp:ListItem> so it no longer says --Select Category-- at the top of the list. The list only contains the items from the database. How can I get the --Select Category-- option to stay there? Thanks for any help.

Jul 5th, 2007, 04:15 PM	#2
techgnome Snarky... Join Date: May 02 Posts: 15,476	Re: Drop down list option disappears It has to be a part of the list that is returned by the data source. -tg __________________ * I don't respond to private requests for help. It's not conducive to the general learning of others.-I also subscribe to all threads I participate, so there's no need to pm when there's an update.* * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft * * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? * On Error Resume Next is error ignoring, not error handling(tm). * Use Offensive Programming, not Defensive Programming. "There is a major problem with your code, and VB wants to tell you what it is.. but you have decided to put your fingers in your ears and shout 'I'm not listening!'" - si_the_geek on using OERN MVP '06-'10

Jul 5th, 2007, 05:54 PM	#3
Webskater Hyperactive Member Join Date: Nov 06 Posts: 420	Re: Drop down list option disappears Thanks for your reply. But, hoping it wasn't true, I have been ferreting around and found that if you set AppendDataBoundItems to true - you can put your 'heading' category at the top and the data bound items appear beneath.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)