Cor & Stand__Sure;
I've tried several things and it's still NOT working properly.
I have a combobox (cbServiceCode) created on the form, so there's no need to
initialize the combobox
below is the code. I hope that you can help me to solve the problem!
Thanks in advance
Bill
1. Use a dataset as cbServiceCode.DataSource. Got error Cannot add new
valuemember!
Private Function AddServiceCode()
Dim dS As DataSet
Dim dSQL As String
Dim mServiceCode, mServiceDesc, mServiceID As String
' Dim mServiceID As Integer
dSQL = "Select * from AC_oxyServices order by oxyServiceCode "
dS = AC_DataBoss.dWFSelectView(dSQL)
cbServiceCode.DataSource = dS
cbServiceCode.DisplayMember = "oxyservicecode"
cbServiceCode.ValueMember = "oxyserviceid"
End Function
2. Use an ArrayList as datasource along with a class (AC_DisplayList)
showing longname and shortname
I got err msg "Argument Prompt cannot be converted to type String" everytime
I click on the box
The box shows the Valuemember instead of displaymember!
Private Function AddServiceCode()
Dim dS As DataSet
Dim dSQL As String
Dim mServiceCode, mServiceDesc, mServiceID As String
' Dim mServiceID As Integer
dSQL = "Select * from AC_oxyServices order by oxyServiceCode "
dS = AC_DataBoss.dWFSelectView(dSQL)
' MsgBox(dS.Tables(0).Rows.Count)
Dim dSRow As DataRow
' Populates the list box using DataSource.
' DisplayMember is used to display just the long name of each state.
Dim mServiceArray As New ArrayList
For Each dSRow In dS.Tables(0).Rows
mServiceCode = Trim(dSRow.Item("oxyServiceCode"))
mServiceDesc = Trim(dSRow.Item("oxyServiceDesc"))
mServiceID = CStr(dSRow.Item("oxyServiceID"))
mServiceArray.Add(New AC_DataBoss.AC_DisplayList(mServiceCode, mServiceID))
'cbServiceCode.Items.Add(m)
Next
cbServiceCode.DataSource = mServiceArray
cbServiceCode.DisplayMember = "LongName"
cbServiceCode.ValueMember = "ShortName"
End Function
"Cor Ligthert" <no************@planet.nl> wrote in message
news:uZ*************@TK2MSFTNGP12.phx.gbl...
Bill,
However, the combobox somehow display the Valuemember instead of
DisplayMember!
What did I do wrong?
Can you show that piece of code frome you,
Cor