How do your read selected values from a BOUND ListBox in VB.Net

[Richard Albrecht]

I have been trying to figure out for days on how to read values from a Bound
ListBox. The listBox gets the values from an Access Table.

I can read values fine for Non-Bound ListBoxes, But the same code doesn't
work for Bound, see below:

Any one of these work for a non-bound listbox.
Code:
'This get all items
For lnCnt = 0 To lstVolIssue.Items.Count - 1
lsVolIssue &= lstVolIssue.Items(lnCnt) & ","
Next

'These 2 methods get only the selected
For Each lsStr In lstVolIssue.SelectedItems
lsVolIssue &= lsStr.ToString
Next

For lnCnt = 0 To lstVolIssue.SelectedIndices.Count - 1
lsVolIssue = lsVolIssue &
lstVolIssue.Items(lstVolIssue.SelectedIndices.Item (lnCnt)).ToString & ","
Next


When using a BOUND listbox the 1st Code Segment
Code:

'This get all items
For lnCnt = 0 To lstVolIssue.Items.Count - 1
lsVolIssue &= lstVolIssue.Items(lnCnt) & ","
Next


Throws This exception
Cast from type 'DataRowView' to type 'String' is not valid.

The Second Code Segment
Code:

'These 2 methods get only the selected
For Each lsStr In lstVolIssue.SelectedItems
lsVolIssue &= lsStr.ToString
Next


Throws the same exception
Cast from type 'DataRowView' to type 'String' is not valid.

And the third segment
Code:

For lnCnt = 0 To lstVolIssue.SelectedIndices.Count - 1
lsVolIssue = lsVolIssue &
lstVolIssue.Items(lstVolIssue.SelectedIndices.Item (lnCnt)).ToString & ","
Next


Returns
System.Data.DataRowView,System.Data.DataRowView,Sy stem.Data.DataRowView,System.Data.DataRowView,

So it has to do with it being bound to a select statement that populates the
list.

HELP!!!

Richard

[Ken Tucker [MVP]]

Hi,

The bound list box will return a datarowview. The string you are
looking for is

Directcast(lstVolIssue.SelectedIndices.Item(lnCnt) ,datarowview).item("YourDisplayMember") Hope that helps.Ken--------------------------"Richard Albrecht" <Ri***************@RAlbrecht.net> wrote in messagenews:5v***************@newssvr33.news.prodi gy.com...I have been trying to figure out for days on how to read values from a BoundListBox. The listBox gets the values from an Access Table.I can read values fine for Non-Bound ListBoxes, But the same code doesn'twork for Bound, see below:Any one of these work for a non-bound listbox.Code:'This get all items For lnCnt = 0 To lstVolIssue.Items.Count - 1 lsVolIssue &= lstVolIssue.Items(lnCnt) & "," Next 'These 2 methods get only the selected For Each lsStr In lstVolIssue.SelectedItems lsVolIssue &= lsStr.ToString Next For lnCnt = 0 To lstVolIssue.SelectedIndices.Count - 1 lsVolIssue = lsVolIssue &lstVolIssue.Items(lstVolIssue.SelectedIndices.Ite m(lnCnt)).ToString & "," NextWhen using a BOUND listbox the 1st Code SegmentCode: 'This get all items For lnCnt = 0 To lstVolIssue.Items.Count - 1 lsVolIssue &= lstVolIssue.Items(lnCnt) & "," NextThrows This exceptionCast from type 'DataRowView' to type 'String' is not valid.The Second Code SegmentCode: 'These 2 methods get only the selected For Each lsStr In lstVolIssue.SelectedItems lsVolIssue &= lsStr.ToString NextThrows the same exceptionCast from type 'DataRowView' to type 'String' is not valid.And the third segmentCode: For lnCnt = 0 To lstVolIssue.SelectedIndices.Count - 1 lsVolIssue = lsVolIssue &lstVolIssue.Items(lstVolIssue.SelectedIndices.Ite m(lnCnt)).ToString & "," NextReturnsSystem.Data.DataRowView,System.Data.Dat aRowView,System.Data.DataRowView,System.Data.DataR owView,So it has to do with it being bound to a select statement that populates thelist.HELP!!!Richard

[Richard Albrecht]

What is "YourDisplayMember" in:

Directcast(lstVolIssue.SelectedIndices.Item(lnCnt) ,datarowview).item("YourDisplayMember")

Thanks

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hi,

The bound list box will return a datarowview. The string you are
looking for is

Directcast(lstVolIssue.SelectedIndices.Item(lnCnt) ,datarowview).item("YourDisplayMember")
Hope that helps.Ken--------------------------"Richard Albrecht"
<Ri***************@RAlbrecht.net> wrote in
messagenews:5v***************@newssvr33.news.prodi gy.com...I have been
trying to figure out for days on how to read values from a BoundListBox.
The listBox gets the values from an Access Table.I can read values fine
for Non-Bound ListBoxes, But the same code doesn'twork for Bound, see
below:Any one of these work for a non-bound listbox.Code:'This get all
items For lnCnt = 0 To lstVolIssue.Items.Count - 1 lsVolIssue &=
lstVolIssue.Items(lnCnt) & "," Next 'These 2 methods get only the
selected For Each lsStr In lstVolIssue.SelectedItems lsVolIssue &=
lsStr.ToString Next For lnCnt = 0 To
lstVolIssue.SelectedIndices.Count - 1 lsVolIssue = lsVolIssue
&lstVolIssue.Items(lstVolIssue.SelectedIndices.Ite m(lnCnt)).ToString & ","
NextWhen using a BOUND listbox the 1st Code SegmentCode: 'This get all
items For lnCnt = 0 To lstVolIssue.Items.Count - 1 lsVolIssue &=
lstVolIssue.Items(lnCnt) & "," NextThrows This exceptionCast from type
'DataRowView' to type 'String' is not valid.The Second Code SegmentCode:
'These 2 methods get only the selected For Each lsStr In
lstVolIssue.SelectedItems lsVolIssue &= lsStr.ToString NextThrows
the same exceptionCast from type 'DataRowView' to type 'String' is not
valid.And the third segmentCode: For lnCnt = 0 To
lstVolIssue.SelectedIndices.Count - 1 lsVolIssue = lsVolIssue
&lstVolIssue.Items(lstVolIssue.SelectedIndices.Ite m(lnCnt)).ToString & ","
NextReturnsSystem.Data.DataRowView,System.Data.Dat aRowView,System.Data.DataRowView,System.Data.DataR owView,So
it has to do with it being bound to a select statement that populates
thelist.HELP!!!Richard

[Ken Tucker [MVP]]

Hi,

The field you are displaying in the listbox

Ken
------------------------
"Richard Albrecht" <Ri***************@RAlbrecht.net> wrote in message
news:iN***************@newssvr17.news.prodigy.com. ..
What is "YourDisplayMember" in:

Directcast(lstVolIssue.SelectedIndices.Item(lnCnt) ,datarowview).item("YourDisplayMember")

Thanks

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hi,

The bound list box will return a datarowview. The string you are
looking for is

Directcast(lstVolIssue.SelectedIndices.Item(lnCnt) ,datarowview).item("YourDisplayMember")
Hope that helps.Ken--------------------------"Richard Albrecht"
<Ri***************@RAlbrecht.net> wrote in
messagenews:5v***************@newssvr33.news.prodi gy.com...I have been
trying to figure out for days on how to read values from a BoundListBox.
The listBox gets the values from an Access Table.I can read values fine
for Non-Bound ListBoxes, But the same code doesn'twork for Bound, see
below:Any one of these work for a non-bound listbox.Code:'This get all
items For lnCnt = 0 To lstVolIssue.Items.Count - 1 lsVolIssue &=
lstVolIssue.Items(lnCnt) & "," Next 'These 2 methods get only the
selected For Each lsStr In lstVolIssue.SelectedItems lsVolIssue &=
lsStr.ToString Next For lnCnt = 0 To
lstVolIssue.SelectedIndices.Count - 1 lsVolIssue = lsVolIssue
&lstVolIssue.Items(lstVolIssue.SelectedIndices.Ite m(lnCnt)).ToString & ","
NextWhen using a BOUND listbox the 1st Code SegmentCode: 'This get all
items For lnCnt = 0 To lstVolIssue.Items.Count - 1 lsVolIssue &=
lstVolIssue.Items(lnCnt) & "," NextThrows This exceptionCast from type
'DataRowView' to type 'String' is not valid.The Second Code SegmentCode:
'These 2 methods get only the selected For Each lsStr In
lstVolIssue.SelectedItems lsVolIssue &= lsStr.ToString NextThrows
the same exceptionCast from type 'DataRowView' to type 'String' is not
valid.And the third segmentCode: For lnCnt = 0 To
lstVolIssue.SelectedIndices.Count - 1 lsVolIssue = lsVolIssue
&lstVolIssue.Items(lstVolIssue.SelectedIndices.Ite m(lnCnt)).ToString & ","
NextReturnsSystem.Data.DataRowView,System.Data.Dat aRowView,System.Data.DataRowView,System.Data.DataR owView,So
it has to do with it being bound to a select statement that populates
thelist.HELP!!!Richard