Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Populate a listbox control from a database - help....pleasePopulate a listbox control from a database - help....please
Previous
 
Next
New Post
3/19/2008 2:08 AM
 

Hi,

I'm working on a DNN module that requires uses to select a number of options from a listbox control. Once the user makes their selections within the listbox control, the data is stored in a database. My challenge is that if a user want's to edit their listbox selections, I don't know how to populate the listbox items from a database indicating which items were selected. Here's the code that I have so far:

 

Dim objPC As New ProjectControllerDim arrPc As ArrayList = objPC.GetProjectsCategories(ProjectId)

 

Dim Item As String

 

 

 

For Each Item In arrPcDim currentCheckBox As ListItem = ChkLstProjectCategories.Items.FindByValue(Item("ProjectCategoryId").ToString())If currentCheckBox IsNot Nothing Then

currentCheckBox.Selected =

True

 

End If

 

Next

 

End Sub

Can anyone see what I'm doing wrong here? Do you have some code to share that would help me get this to work?

Many thx

Brad

 

 
New Post
12/4/2008 7:04 PM
 

Hope this helps.

To select an item for a listbox do the following:

Populate the listbox as you normally would.

After populating try the following, to which you'll need to supply the listbox name as indicated by yourListBoxIDhere

yourListBoxIdHere.SelectedItem = yourListBoxIdHere.Items.IndexOf(yourListBoxIdHere.Items.FindByValue("WhatYouAreLookingFor"))

The only thing I don't know is how to get it to select multiple values, should you allow that. Also, most likely WhatYouAreLookingFor is probably going to be an int or Integer since you might have it as an index value of some sort from your database.

Hope that helps.

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Populate a listbox control from a database - help....pleasePopulate a listbox control from a database - help....please


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out