ListBox, DataReader, ID and Description

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Guy Dillen - 04 Dec 2004 09:17 GMT

I would like using a DataReader to fille a listbox with descriptions, on the
other hand i need to store somwhere an ID (to the respective Descriptions),
that i can use as a key when a listbox item has ben selected.

I know i can use a second invisible listbox that stores the ID's in it, but
are there alternatives to solve this problem (with a DataReader) more
elegant? Maybe using the Tag property?

Thanks
Guy

Reply to this Message

Herfried K. Wagner [MVP] - 04 Dec 2004 11:25 GMT

"Guy Dillen" <guy_dillen@nospam.hotmail.com> schrieb:

>I would like using a DataReader to fille a listbox with descriptions, on
>the other hand i need to store somwhere an ID (to the respective
>Descriptions), that i can use as a key when a listbox item has ben
>selected.

Take a look at the control's 'DisplayMember', 'ValueMember', and
'DataSource' properties.

Signature

Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/

Reply to this Message

Guy Dillen - 04 Dec 2004 11:56 GMT

Ok, i already did, but does DataSource/DisplayMember/ValueMember also work
with a DataReader?

Guy

> "Guy Dillen" <guy_dillen@nospam.hotmail.com> schrieb:
>>I would like using a DataReader to fille a listbox with descriptions, on
[quoted text clipped - 4 lines]
> Take a look at the control's 'DisplayMember', 'ValueMember', and
> 'DataSource' properties.

Reply to this Message

Nicola - 04 Dec 2004 13:35 GMT

I don't think it's possible, but why use DataReader ???
I implemented it filling a table, added to a DataSet through a DataAdapter:

Dim DS as DataSet
Dim N as string="TableName"
Dim SQL as string="SELECT * FROM ..."
Dim CN as New SQLConnection(ConnectionString)
Dim CMD As New SqlCommand(SQL, CN), DA As New SqlDataAdapter(CMD)
DS.Tables.Add(N) : DA.Fill(DS.Tables(N))
ListBox.ValueMember = ID
ListBox.DisplayMember = Description
ListBox.DataSource = DS.Tables(N)
ListBox.SelectedIndex = -1 : ListBox.SelectedIndex = -1

I hope this can help You
nq

> Ok, i already did, but does DataSource/DisplayMember/ValueMember also work
> with a DataReader?
[quoted text clipped - 9 lines]
> > Take a look at the control's 'DisplayMember', 'ValueMember', and
> > 'DataSource' properties.

Reply to this Message

ListBox, DataReader, ID and Description

Free Magazines