asp.net dropdownlist - add blank line before db values

asp.net drop-down-menu sqldatasource dropdownbox
thegunner picture thegunner · Jun 11, 2009 · Viewed 64.8k times · Source

On my page I have a DropDownList which I populate with database values from an SqlDataSource (see code below).

How can I add my own text or a blank line before the values?

<asp:DropDownList ID="drpClient" runat="server" Width="200px" 
    AutoPostBack="True" DataSourceID="dsClients" DataTextField="name" 
        DataValueField="client_id">
</asp:DropDownList>
<asp:SqlDataSource ID="dsClients" runat="server" 
    ConnectionString="my_connection_string" 
    ProviderName="System.Data.SqlClient" 
    SelectCommand="SELECT [client_id], [name] FROM [clients]">
</asp:SqlDataSource>

Thanks.

P.S. Do you recommend using a SqlDataSource or is it better to populate another way?

Answer

Jose Basilio picture Jose Basilio · Jun 11, 2009

You can simply add a ListItem inside the DropDownList Markup. All the values from the DataSource will be appended after that.

<asp:DropDownList ID="drpClient" runat="server" Width="200px" 
          AutoPostBack="True" DataSourceID="dsClients" DataTextField="name" 
          DataValueField="client_id" AppendDataBoundItems="true">
   <asp:ListItem>-- pick one --</asp:ListItem>
</asp:DropDownList>

Related questions

ASP.Net: drop down list and data source created dynamically

I have about 10 drop down list controls that get populated. Instead of copying/pasting and modifying a few fields on each, I would like to create them programmatically. Can this be done? Here is what one of them looks like. …

Read More
DropDownList's SelectedIndexChanged event not firing

I have a DropDownList object in my web page. When I click on it and select a different value, nothing happens, even though I have a function wired up to the SelectedIndexChanged event. First, the actual object's HTML code: <…

Read More
How to add an item to a drop down list in ASP.NET?

I want to add the "Add new" at a specific index, but I am not sure of the syntax. I have the following code: protected void Page_Load(object sender, EventArgs e) { DRPFill(); if (!IsPostBack) { DropDownList1.Items.Add("Add New"); } } …

Read More