Default item at the top of a Drop Down List

Question

User694418659 posted

Hi all,

I have this code in a page which pulls drop down list items from a Access mdb:

<asp:DropDownList id="DropDownList1" runat="server" DataSourceID="AccessDataSource1" DataTextField="Category_1" DataValueField="Category_1" CssClass="TextBox">

</asp:DropDownList>

Is there anything I can add to this line (or anywhere else) which will appear as the default option at the top of the list eg "---Select---"?
What's happening at the moment is that when the page loads, the first item from the drop down list in the mdb is being automatically used by the code above to return a whole bunch of records. 

Mart

Answer 1

User-943250815 posted

Set AppendDataBoundItens and add "Select" as ListItem

<asp:DropDownList id="DropDownList1" runat="server" AppendDataBoundItems="True" DataSourceID="AccessDataSource1" DataTextField="Category_1" DataValueField="Category_1" CssClass="TextBox">
<asp:ListItem>Select</asp:ListItem>
</asp:DropDownList>

Answer 2

User694418659 posted

Aha! Thanks. :-)