[2005] Listbox Selected Items

Hi There,

I'm still struggling. I want the user to select only eight items and then I would like to add those eight Selecteditems to a table in Access a database. How do I add Listbox Selected items to a table?

Hi
Just add an insert sql statement in the middle the cycle.
How to browse the selected items of a ListBox

Code:

---

For i As Int32 = 0 To Me.ListBox1.SelectedItems.Count - 1
            Console.WriteLine(Me.ListBox1.SelectedItems(i).ToString)
Next

---

Hi,

thanks for your help I highly appreciate it, but now instead of retrieving each column I'm retrieving rows.:thumb:

Is this you wanted ?

Code:

---

Dim sSelitem() As String
        ListBox1.SelectedItems.CopyTo(sSelitem, 0)

---

This will copy the selected item into a string array

Hi

Thanks for your help it works just fine.