Hi. This is using VB.NET and Access. I am populating a listbox via datasource from an Access Database on FormLoad. I have the listbox set for multi selection. My problem is when I attempt to retrieve the selected items I am getting errors. I have been trying to use the SelectedItems of the ListBox. If I take away the DataSource and load the contents manually, it works fine. I am thinking that using ADO you must retrieve the selected items a different way, but I cannot find anything on the net for a solution. Any help would be greatly appreciated.

Thanks

Can you post the code related to the problem? Once you have items in a listbox, it shouldn't matter how they got there.

The below code will work fine if I just add my items in the items properity manually. Each selected item appears correctly in the MessageBox.

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim i As Integer

        For i = 0 To ListBox2.SelectedItems.Count - 1
            MessageBox.Show(ListBox2.SelectedItems(i).ToString ())
        Next

    End Sub
End Class


When I change the ListBox to use the following properties I get 'System.Data.DataRowView' in the MessageBox instead of the actual item:

        DataSource: DataSet21
        DisplayMember: Accessories.Accessories
        ValueMember: Accessories.ID

The ListBox loads the data fine, I just can't seem to access the items appropriately.

Please let me know if you need further information.

See if this post helps you out:

http://p2p.wrox.com/topic.asp?TOPIC_ID=13452

It has several examples on accessing items in a combobox, but the code for a listbox is very similar.

J

Thank you katsarosj that link was very useful. I am now able to view all of the items in my listbox, however I only want to retrieve the selected items. Would you know how to modify the code below to that?

        For Each MyItem As DataRowView In ListBox2.Items
            MessageBox.Show(MyItem.Item("accessories").ToStrin g())
        Next

Ok, I got it all you have to do is change ListBox2.Items to ListBox2.SelectedItems.

Thanks to all that have helped me get this solved.