[2005] Listbox Selected Items

[Similija]

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?

[Asgorath]

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

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

[Similija]

Hi,

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

[danasegarane]

Is this you wanted ?

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

This will copy the selected item into a string array

[Similija]

Hi

Thanks for your help it works just fine.