Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1012
  • Last Modified:

DropDownList - First row must be empty

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.


Peter
0
Contestoas
Asked:
Contestoas
1 Solution
 
Swapnil PipariaArchitectCommented:
Hi Contestoas,
you can add dropdown item after pupulating it as following
dropdownlist1.items.insert(0," ")

Regards,
NetSwap
0
 
ContestoasAuthor Commented:
Hi
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 .

Peter
0
 
rstraderCommented:
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

        Try
           myConnection.Open()

           myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)

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

    End Sub
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now