Solved

Get ValueMembers from a Databound Multiselect ListBox

Posted on 2004-08-12
6
4,418 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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

762 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

24 Experts available now in Live!

Get 1:1 Help Now