Hi,

2 questions...

1) i have a list box control with multiple items selcted which i ma trying to save to a database with a stored procedure. But only the first slected item ever gets saved. I am using the .selecteditem.value option. How do i get all the selected items to pass.

2) i have 2 list boxes. List box 1 passes items to listbox 2. I now need to pass the items in listbox 2 to a database, but i cannot make it work because noting is selected. How do i pass the listbox 2 items without having to select them individually.

Someone please help

Thanks

Anton

Either way, to get multiple selected items into anything else (a file, a DB, etc) you need to treat your list as an array (which it actually is) and iterate all the items in the list using a For-Each loop, testing to see if .selected = true for each item....

example below is looking for selected items in a listview control (listviewitem) but just change it for a listbox control (listitem I think) (see vb.net help):

Private Function GetQName() As String
        '//strip q name
        Dim qName As ListViewItem
        For Each qName In lvwQueues.Items
            If qName.Selected = True Then

                     '// do push to database here

            End If
        Next
        qName = Nothing
End Function


The above is from a program I wrote for work, dealing with lists of message queues in a listview control. You can use the above as a guide just make sure your iteration object matches the control (listbox = listitem i think) see vb help.

hope this helps
James