Solved

Get ValueMembers from a Databound Multiselect ListBox

Posted on 2004-08-12
6
4,425 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
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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…
If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

807 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