Dropdown Problem

[Kreuzer Michael]

Hi all,

I have a problem: i want a full table of a Access DB in a Dropdown list. In the database, there is one table with index, name,
telephonenumber.

I have the OleDB Adapter & Dataset, but now i dont know how i can get this stuff into the dropdown, and i also dont know, if the
dropdown can manage more than 1 element.

Usually anyone can help me.

Thx,
Michael

PS: After this problem, i must know, how i can get the selected telephonenumber into a variable.

[Ken Tucker [MVP]]

Hi,

Add a new calculated column to your dataset. Use that column as the
displaymember in the combobox.
Dim dc As DataColumn

'

' Add a new column in clients table which

' is full name.

dc = New DataColumn("DisplayInfo")

dc.DataType = System.Type.GetType("System.String")

dc.Expression = "Index + ' ' + Name + ' ' + telephonenumber"

dsClient.Tables(0).Columns.Add(dc)

Ken

--------------------
"Kreuzer Michael" <ze*******@aon.at> wrote in message
news:2u*************@uni-berlin.de...
Hi all,

I have a problem: i want a full table of a Access DB in a Dropdown list. In
the database, there is one table with index, name,
telephonenumber.

I have the OleDB Adapter & Dataset, but now i dont know how i can get this
stuff into the dropdown, and i also dont know, if the
dropdown can manage more than 1 element.

Usually anyone can help me.

Thx,
Michael

PS: After this problem, i must know, how i can get the selected
telephonenumber into a variable.

[Ken Tucker [MVP]]

Hi,

Add a new calculated column to your dataset. Use that column as the
displaymember in the combobox.
Dim dc As DataColumn

'

' Add a new column in clients table which

' is full name.

dc = New DataColumn("DisplayInfo")

dc.DataType = System.Type.GetType("System.String")

dc.Expression = "Index + ' ' + Name + ' ' + telephonenumber"

dsClient.Tables(0).Columns.Add(dc)

Ken

--------------------
"Kreuzer Michael" <ze*******@aon.at> wrote in message
news:2u*************@uni-berlin.de...
Hi all,

I have a problem: i want a full table of a Access DB in a Dropdown list. In
the database, there is one table with index, name,
telephonenumber.

I have the OleDB Adapter & Dataset, but now i dont know how i can get this
stuff into the dropdown, and i also dont know, if the
dropdown can manage more than 1 element.

Usually anyone can help me.

Thx,
Michael

PS: After this problem, i must know, how i can get the selected
telephonenumber into a variable.