Get ValueMembers from a Databound Multiselect ListBox

Hi everybody,
I am kinda stuck with this. Let me explain...

This is a Windows Application. I have a listbox that is bound to a dataset table.

        SqlCon.Open()
        DA.Fill(DS)         'DA is Adapter, DS is DataSet
        SqlCon.Close()
        ListBox1.DisplayMember = "EmpName"
        ListBox1.ValueMember = "EmpID"
        ListBox1.DataSource = DS.Tables(0)

Everything works fine. Now all I need is to get the ValueMembers for selected items in the list box. Lets make a string with all the values...

        Dim itm As Object
        Dim ValueString As String = "Selected Values are : "
        For Each itm In ListBox1.SelectedItems
            ValueString &= ListBox1.SelectedValue.ToString() & ", "
       Next
       MsgBox(ValueString)

===========================
What I am getting now:

If I select only a single Item, I get the right value.

But, when I select multiple items, it gives me the first value all the time. What I meant is, say I selected 3 items, and my first VALUE is 40. Then my ValueString is : "Selected Values are : 40, 40, 40, "... this is what I am getting.

Need to get it right ...  anybody ??

-Baan
LVL 18
DotNetLover_BaanAsked:
Who is Participating?
 
bramsquadCommented:
ok, got it.....this should be what you need

        Dim ValueString As String = "Selected Values are : "

        Dim i, index, count As Integer
        count = ListBox1.SelectedItems.Count - 1

        For i = 0 To count
            ValueString += ListBox1.SelectedValue.ToString + ", "

            index = ListBox1.SelectedIndices.Item(0)
            ListBox1.SetSelected(index, False)
        Next

        MsgBox(ValueString)

becuase it couldnt deal with the multiple selections, i deseleted each value as i added it to the string.

~b
0
 
bramsquadCommented:
here ya go

        Dim ValueString As String = "Selected Values are : "

        Dim i As Integer
        For i = 0 To ListBox1.SelectedItems.Count - 1
            ValueString += ListBox1.SelectedItems.Item(i) + ", "
        Next

~b
0
 
DotNetLover_BaanAuthor Commented:
no good...
let me make it clearer...  I am trying to get the "SelectedValue"s behind the displayed Items.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
DotNetLover_BaanAuthor Commented:
Still having problem with... >>  ValueString += ListBox1.SelectedValue.ToString + ", " <<

Anyway I found a work arround. Instead of multi-selection, I am coding for the DoubleClick event of the ListBox. I am making the user to work with single item at a time.

I will leave this post open for couple of days, for a decent solution to this. I am also trying. If I don't find any solution , I will award you the points for working with me.
BUT , please don't disregard this question, its a very important matter, we never thought.
Thanks for your help... :)
-Baan
0
 
bramsquadCommented:
what problem are you having, i set up everything, dataset, adapter, valuemember, displaymember, everything....and it works perfectly for me....

'this gets the first value (just like you got)
ValueString += ListBox1.SelectedValue.ToString + ", "

'this gets teh index of the selected value
index = ListBox1.SelectedIndices.Item(0)

'this deselects the first value (so you have another "first" one the next loop around)
ListBox1.SetSelected(index, False)

if you go into the debugger, itll show you that the number of selected indices shrinks.  let me  know your problem, i spent a couple hours trying to figure this out....

0
 
DotNetLover_BaanAuthor Commented:
Thanks for your help.
I know this is working. I tested it, and it works fine for me too. But the application I am working on is quite a bit different. Everytime I tried that, it selects System.DataView... this happens when there is some error on selecting data or, when somehow table inside the dataset becomes NULL. I guess my problem is somewhere else. Anyway, thanks for you help. By the way... you did a real good job here. Thanks again.
You have answered my question perfectly... you deserve the points. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.