ComboBox select Values How?

[Eric]

Im populating a combobox from query results like that
below. This works great for populating the box, but I dont
want the selected text, but the ID info associated with
the selection. The query returns Name,ID. I only want to
display the Name in the box, but pull the ID value as the
selected value. I could do this with web forms in .net,
but not with Windows forms controls. Any help would be
great.
EXAMPLE:
Dim dreader As SqlClient.SqlDataReader
DTE.Open()
dreader = SelectExpense.ExecuteReader()
While dreader.Read()
CBO_EType.Items.Add(dreader(0).ToString())
End While
..

[Rob Windsor]

Eric,

Use the DisplayMember and ValueMember properties of the ComboBox. Code
example follows:
Private loading As Boolean

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim cn As New SqlConnection("Server=(local);Database=Pubs;Integr ated
Security=SSPI")
Dim da As New SqlDataAdapter("SELECT au_lname, au_id FROM Authors",
cn)
Dim dt As New DataTable

loading = True
da.Fill(dt)
ComboBox1.DataSource = dt
ComboBox1.DisplayMember = "au_lname"
ComboBox1.ValueMember = "au_id"
loading = False
End Sub

Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ComboBox1.SelectedIndexChanged
If Not loading Then
MsgBox(ComboBox1.SelectedValue.ToString)
End If
End Sub
"Eric" <er*************@kutakrock.com> wrote in message
news:01****************************@phx.gbl...

Im populating a combobox from query results like that
below. This works great for populating the box, but I dont
want the selected text, but the ID info associated with
the selection. The query returns Name,ID. I only want to
display the Name in the box, but pull the ID value as the
selected value. I could do this with web forms in .net,
but not with Windows forms controls. Any help would be
great.
EXAMPLE:
Dim dreader As SqlClient.SqlDataReader
DTE.Open()
dreader = SelectExpense.ExecuteReader()
While dreader.Read()
CBO_EType.Items.Add(dreader(0).ToString())
End While
.

[Rob Windsor]

Eric,

Use the DisplayMember and ValueMember properties of the ComboBox. Code
example follows:

--
Rob Windsor
G6 Consulting
Toronto, Canada

Private loading As Boolean

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim cn As New SqlConnection("Server=(local);Database=Pubs;Integr ated
Security=SSPI")
Dim da As New SqlDataAdapter("SELECT au_lname, au_id FROM Authors",
cn)
Dim dt As New DataTable

loading = True
da.Fill(dt)
ComboBox1.DataSource = dt
ComboBox1.DisplayMember = "au_lname"
ComboBox1.ValueMember = "au_id"
loading = False
End Sub

Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ComboBox1.SelectedIndexChanged
If Not loading Then
MsgBox(ComboBox1.SelectedValue.ToString)
End If
End Sub
"Eric" <er*************@kutakrock.com> wrote in message
news:01****************************@phx.gbl...

Im populating a combobox from query results like that
below. This works great for populating the box, but I dont
want the selected text, but the ID info associated with
the selection. The query returns Name,ID. I only want to
display the Name in the box, but pull the ID value as the
selected value. I could do this with web forms in .net,
but not with Windows forms controls. Any help would be
great.
EXAMPLE:
Dim dreader As SqlClient.SqlDataReader
DTE.Open()
dreader = SelectExpense.ExecuteReader()
While dreader.Read()
CBO_EType.Items.Add(dreader(0).ToString())
End While
.

[Eric]

Thanks Rob, It seems like a ton of overhead; populating a
dataset then binding to it, but whatever works.
much thanks, Eric

-----Original Message-----
Eric,

Use the DisplayMember and ValueMember properties of the ComboBox. Codeexample follows:

--
Rob Windsor
G6 Consulting
Toronto, Canada

Private loading As Boolean

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e AsSystem.EventArgs) Handles MyBase.Load
Dim cn As New SqlConnection("Server= (local);Database=Pubs;IntegratedSecurity=SSPI")
Dim da As New SqlDataAdapter("SELECT au_lname, au_id FROM Authors",cn)
Dim dt As New DataTable

loading = True
da.Fill(dt)
ComboBox1.DataSource = dt
ComboBox1.DisplayMember = "au_lname"
ComboBox1.ValueMember = "au_id"
loading = False
End Sub

Private Sub ComboBox1_SelectedIndexChanged(ByVal sender AsSystem.Object, ByVal e As System.EventArgs) Handles
ComboBox1.SelectedIndexChanged
If Not loading Then
MsgBox(ComboBox1.SelectedValue.ToString)
End If
End Sub
"Eric" <er*************@kutakrock.com> wrote in message
news:01****************************@phx.gbl...

Im populating a combobox from query results like that
below. This works great for populating the box, but I dont want the selected text, but the ID info associated with
the selection. The query returns Name,ID. I only want to
display the Name in the box, but pull the ID value as the selected value. I could do this with web forms in .net,
but not with Windows forms controls. Any help would be
great.
EXAMPLE:
Dim dreader As SqlClient.SqlDataReader
DTE.Open()
dreader = SelectExpense.ExecuteReader()
While dreader.Read()
CBO_EType.Items.Add(dreader(0).ToString())
End While
.

.