Listbox Question

[Ed Bick]

I added items to a listbox as follows:

Dim datDrivers As New SqlConnection(SQL_CONNECTION_CB)
Dim adpDrivers As New
SqlDataAdapter(MySelectStatement,datDrivers)
adpDrivers.Fill(DriverData, DRIVER_TABLE_NAME)
lstDrivers.DataSource = DriverData.Tables(DRIVER_TABLE_NAME)
lstDrivers.DisplayMember = "Name"
lstDrivers.ValueMember = "DriverID"

I am trying to retrieve the value assigned by this

lstDrivers.ValueMember = "DriverID"

By using a statement like this

Dim strDriverID As String = lstDrivers.SelectedItem.ToString

But all I'm getting is this

System.Data.DataRowView (the value displayed in watches for strDriverID)

What am I doing wrong?

[Ken Tucker [MVP]]

Hi,
Dim drv as DataRowView = lstDrivers.SelectedItem
Dim strDriverID As String = drv("DriverID")

Ken
-----------------
"Ed Bick" <no******@comcast.net> wrote in message
news:R6********************@comcast.com...

I added items to a listbox as follows:

Dim datDrivers As New SqlConnection(SQL_CONNECTION_CB)
Dim adpDrivers As New
SqlDataAdapter(MySelectStatement,datDrivers)
adpDrivers.Fill(DriverData, DRIVER_TABLE_NAME)
lstDrivers.DataSource = DriverData.Tables(DRIVER_TABLE_NAME)
lstDrivers.DisplayMember = "Name"
lstDrivers.ValueMember = "DriverID"

I am trying to retrieve the value assigned by this

lstDrivers.ValueMember = "DriverID"

By using a statement like this

Dim strDriverID As String = lstDrivers.SelectedItem.ToString

But all I'm getting is this

System.Data.DataRowView (the value displayed in watches for strDriverID)

What am I doing wrong?

[Cor]

Hi Ed,

Does this do it?

Dim strDriverID As String = lstDrivers.SelectedItem.ToString

Dim strDriverId as String = lstDrivers.SelectedValue.ToString,

I hope this helps?

Cor

[Ed Bick]

Ken,

Bingo, thanks. But please look at my response to your response on the
Datagrid ?

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:#$**************@TK2MSFTNGP11.phx.gbl...

Hi,
Dim drv as DataRowView = lstDrivers.SelectedItem
Dim strDriverID As String = drv("DriverID")

Ken
-----------------
"Ed Bick" <no******@comcast.net> wrote in message
news:R6********************@comcast.com...

I added items to a listbox as follows:

Dim datDrivers As New SqlConnection(SQL_CONNECTION_CB)
Dim adpDrivers As New
SqlDataAdapter(MySelectStatement,datDrivers)
adpDrivers.Fill(DriverData, DRIVER_TABLE_NAME)
lstDrivers.DataSource = DriverData.Tables(DRIVER_TABLE_NAME)
lstDrivers.DisplayMember = "Name"
lstDrivers.ValueMember = "DriverID"

I am trying to retrieve the value assigned by this

lstDrivers.ValueMember = "DriverID"

By using a statement like this

Dim strDriverID As String = lstDrivers.SelectedItem.ToString

But all I'm getting is this

System.Data.DataRowView (the value displayed in watches for strDriverID)
What am I doing wrong?

[Armin Zingler]

"Ed Bick" <no******@comcast.net> schrieb

I added items to a listbox as follows:

Dim datDrivers As New SqlConnection(SQL_CONNECTION_CB)
Dim adpDrivers As New
SqlDataAdapter(MySelectStatement,datDrivers)
adpDrivers.Fill(DriverData, DRIVER_TABLE_NAME)
lstDrivers.DataSource =
DriverData.Tables(DRIVER_TABLE_NAME) lstDrivers.DisplayMember =
"Name"
lstDrivers.ValueMember = "DriverID"

I am trying to retrieve the value assigned by this

lstDrivers.ValueMember = "DriverID"

By using a statement like this

Dim strDriverID As String =
lstDrivers.SelectedItem.ToString

But all I'm getting is this

System.Data.DataRowView (the value displayed in watches for
strDriverID)

What am I doing wrong?

Untested: Use lstDrivers.SelectedValue
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html