Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


DropDownList - First row must be empty

Posted on 2006-06-22
Medium Priority
Last Modified: 2012-06-27
Hi !
I'm using ASP.NET 2.0 and VS 2005

In my form I have a DropDownList that is populated with a SQLDataSource SELECT DISTINCT ......etc.

I need the DropDownList to have one empty row first so the user does not have to make a selection.

Question by:Contestoas
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 16

Accepted Solution

Swapnil Piparia earned 1000 total points
ID: 16958612
Hi Contestoas,
you can add dropdown item after pupulating it as following
dropdownlist1.items.insert(0," ")


Author Comment

ID: 16958800
I Tried putting the code in Page_Load Event but the empty row did not show !
On what event should I put the code??

The DropDownList is bound directly to a SQLDataSource object on the page .....
.... so I guess that I should add the code after the SQLDataSource has finished poplulating the DropDownList .


Expert Comment

ID: 16958911
page_load is the right spot, and your right it would need to happen after the SQLDataSource databind - I'd also check postback and only populate the list once on initial page load, here is a sample

 Sub Page_Load(sender As Object, e As EventArgs)
      If Not Page.IsPostBack Then
          Dim myConnection As SqlConnection = new SqlConnection(ConfigurationSettings.AppSettings("pubs"))

        Dim myCommand As SqlCommand = new SqlCommand("Select pub_id, pub_name From publishers", myConnection)
        Dim myDataReader As SqlDataReader


           myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)

           DropDownList1.DataSource = myDataReader
        Catch myException As Exception
           Response.Write("An error has occurred: " & myException.ToString())
           If Not myDataReader Is Nothing Then
           End If
              DropDownList1.Items.Insert(0, " ")
           DropDownList1.SelectedIndex = 0
        End Try
      End If

    End Sub

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question