Please help

[Kosal]

Dear All

I have problem with code as below:

 
strSQL = "SELECT * FROM tblBooking WHERE (bIssureDate BETWEEN '" & FromDate.ToString("dd MMM yyyy") & "' AND '" & ToDate.ToString("dd MMM yyyy") & "')AND bStatus='" & cboStatus.Text & "'"
Try
DBCon.Open()
cboPNR.Focus()
Dim DBcom As New Odbc.OdbcCommand(strSQL, DBCon)
Dim objreader As Odbc.OdbcDataReader = DBcom.ExecuteReader()
Do While objreader.Read()
cboPNR.Items.Add(objreader("bPNR"))
Loop
Catch ex As Exception
MsgBox(ex.Message)
Finally
DBCon.Close()
End Try

I need to set Display Member = "bPNR" and Value Member="bID" so how can I add it.

Please help

[r035198x]

Please don't double post.

[Kosal]

Sorry for double post