470,815 Members | 1,237 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,815 developers. It's quick & easy.

Multiselect Listboxes


I am working with two listboxes that are initially getting populated from database tables (Access). They basically allow the user to transfer information back and forth from one listbox to the other listbox WITHOUT affecting the database.

My question is this. When the user selects <Save Changes>, I want to be able to update the database table with the information in Listbox1. Basically like a security setup utility. What's my best option?

My solution would be to store the original entries of Listbox1 in Array1, then once the use selects the <Save Changes>, store the new set of Listbox1 entries in Array2. Compare with some sort of looping routine. If more entries exist, do a SQL Insert. If less, do a SQL Delete.

These listboxes are very limited in methods and properties. They are specific to an SAP application software.

Thank you.
Sep 18 '07 #1
1 1606
5,390 Expert Mod 4TB
hi ...

welcome to TSDN ...

could you please post some code you have so far? the idea to link the listboxes with js arrays sounds good ... but you may consider objects ... so you might optimize the runtime behaviour of the list-compare-operation. have a look at this article ...

kind regards
Sep 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by cableguy | last post: by
reply views Thread by deejayquai | last post: by
3 posts views Thread by Lenard Gunda | last post: by
5 posts views Thread by doncee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.