How to Iterate a Bound Listbox?

[Daryll SHatz]

What object is returned by a bound (to a DataSet) ListBox when it is
iterated?

Listbox.DataSource = DataSet1.MyTable
ListBox.DisplayMember = "Col1"
ListBox.ValueMember = "Col2"

Dim s as String
For Each itm In ListBox.Items
' what goes here to output the display text for each item in the
listbox?
s = itm.?????
Next

' I need s to be the values of Col1 displayed in the listbox.

[William Ryan]

ListBoxName.Items.Add(itm.text)
"Daryll SHatz" <ds****@cox.net> wrote in message
news:#q**************@TK2MSFTNGP10.phx.gbl...

What object is returned by a bound (to a DataSet) ListBox when it is
iterated?

Listbox.DataSource = DataSet1.MyTable
ListBox.DisplayMember = "Col1"
ListBox.ValueMember = "Col2"

Dim s as String
For Each itm In ListBox.Items
' what goes here to output the display text for each item in the
listbox?
s = itm.?????
Next

' I need s to be the values of Col1 displayed in the listbox.

[Mike Hofer]

The item should be a DataRow object.

If you're unsure, place a breakpoint in your For-Each loop, and look in the
Locals window to determine the type.

Hope this helps.
Mike

"Daryll SHatz" <ds****@cox.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

What object is returned by a bound (to a DataSet) ListBox when it is
iterated?

Listbox.DataSource = DataSet1.MyTable
ListBox.DisplayMember = "Col1"
ListBox.ValueMember = "Col2"

Dim s as String
For Each itm In ListBox.Items
' what goes here to output the display text for each item in the
listbox?
s = itm.?????
Next

' I need s to be the values of Col1 displayed in the listbox.