Solved

VB.net store/select values in multiline listbox based on DB tables.

Posted on 2007-03-22
4
1,025 Views
Last Modified: 2010-05-18
Hi,

I have a pretty simple VB.net page displaying a logged in user's preferences that I am trying to add a new control to. I'm adding a multi line listbox which loads a list of countries from a table (lets say tblCountry). This table contains reference data of country names and country IDs.

However, when this listbox is loaded, I want it to select countries based on the current user's "preferred countries". Which means I need to store the user's selected countries in a different table somewhere - not the tblCountry table.

I have no problems loading the country list from tblCountry and binding it to the listbox but I can't work out how to also load and store the selected countries into another table and update the selected values of the multiline listbox on this user preferences page.

Any ideas?
0
Comment
Question by:bradderick
  • 2
  • 2
4 Comments
 
LVL 5

Accepted Solution

by:
jef06 earned 500 total points
ID: 18778032
You can do an LEFT OUTER JOIN with this other table, and if the value is null it means that the user does not have selected anything otherwise you have the value previously selected.
0
 

Author Comment

by:bradderick
ID: 18778050
Okay that sounds like it would work. But how to set the Selected property for the appropriate countries in the listbox then?

Currently the DataTextField property is set to the field  "CountryName" and DataValueField property is set to "iCountryID" before the databind.

How do I set the selected items based on the outerjoin you mentioned?
0
 
LVL 5

Expert Comment

by:jef06
ID: 18778063
If you can select multiple countries use the left outer join and use LisItem and for each element check if there is a value, but it looks like you can select only one country in your case, it might be better to create a method that return the country selected and you set the SelectedIndex in looping threw your values.
0
 

Author Comment

by:bradderick
ID: 18783685
No actually you were right in the first place - the user can select multiple countries. Can you wlaborate a little more about the listitem method?

Any example code would be excellent!
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Not showing page correctly 3 29
.Net Web Site IIS Web.Config Content-Security-Policy 1 34
Connection String 16 41
Point to Current Row Ater Refresh Datagridview 3 19
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

929 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now