Solved

Get ValueMembers from a Databound Multiselect ListBox

Posted on 2004-08-12
6
4,421 Views
Last Modified: 2008-06-08
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
0
Comment
Question by:DotNetLover_Baan
  • 3
  • 3
6 Comments
 
LVL 8

Expert Comment

by:bramsquad
ID: 11786127
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
 
LVL 18

Author Comment

by:DotNetLover_Baan
ID: 11786349
no good...
let me make it clearer...  I am trying to get the "SelectedValue"s behind the displayed Items.
0
 
LVL 8

Accepted Solution

by:
bramsquad earned 500 total points
ID: 11787125
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 18

Author Comment

by:DotNetLover_Baan
ID: 11787857
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
 
LVL 8

Expert Comment

by:bramsquad
ID: 11788292
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
 
LVL 18

Author Comment

by:DotNetLover_Baan
ID: 11789145
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now