Hi,

Can I ask if this is the preferred method of dealing with dropdownlists and setting the selected item to a specific value contained in a record. If you imagine that I have a table of clubs and to edit a club I load a ClubEdit page. Now my regions dropdown list is set to the values within a region table like so when the page loads:

Dim regionlist As SqlDataReader = Regions.GetRegions()


  cboRegion.DataSource = regionlist


  cboRegion.DataValueField = "RegionID"


  cboRegion.DataTextField = "Region"


  cboRegion.DataBind()

Now when I want to load a particular club I want to set the values in any dropdown to the values in the club table i.e. the RegionID field and Region (name) from my query results ...

'set regionlist to the current value


    With cboRegion


          'add a default item to the dropdown


           cboRegion.Items.Insert(0,"")


           cboRegion.SelectedIndex = 0


           .SelectedItem.Value = dr("RegionID")


           .SelectedItem.Text = dr("Region")


     End With

I find that if I do not use the

cboRegion.Items.Insert(0,"") ...etc

bit I simply end up overwriting the first item in the list so my dropdown contains all the items minus one.

So what I am asking is .... is this how you great wise ones deal with this??

Tips and tricks for my arsenal gratefully recieved.

Laura D

When the page loads, the first item in the dropdown list is selected by default (unless you specify otherwise). So, when you use this: .SelectedItem.Value = dr("RegionID"), it changes the value of of the selected item (item 0, or the first item). I do not think this is not what you are trying to accomplish. If I understand correctly, you are trying to select the the item in the dropdownlist that matches the current value. To accomplish this, you need to bind the list to the datasource, then loop through the list until you find a match for the current value.

Dim i as Integer


For i = 0 to cboRegion.Items.Count - 1


If cboRegion.SelectedItem.Value = dr("RegionID") then


cboRegion.SelectedIndex = i


End If


Next

---

Jared Livingston
MrLivingston.com - Livingston Family Website

Test/Demo site - moonmark.com

Hmm

Of course that looks so obvious!!! I should take a break from the screen sometimes and sit back and think a bit more ...

Thanks ....

Well ... I couldn't get that to work - always selects the first item in the list.

Got this to work though:

'set regionlist to the current value


dim selectedregion as integer


selectedregion = dr("RegionID")


cboRegion.Items.FindByValue(selectedregion).Selected = True

Not too sure why the previous method wouldn't work .. will ponder that on the train in the morning.

Laura D