hi experts

During my development progress i was stuck up with a problem.
I used a class MyList and with the Help of this MyList the combo box named cboCity was filled with City Code(like 1001,1002,etc..) as Value member and City Name (like Canada,California etc...) as display member.

Public Class MyList
    Private _dispName As String
    Private _valMember As Integer
    Public Sub New()
        _dispName = ""
        _valMember = 0
    End Sub
    Public Sub New(ByVal dispName As String, ByVal valMember As Integer)
        _dispName = dispName
        _valMember = valMember
    End Sub
    Public Property DisplayName() As String
            Return _dispName
        End Get
        Set(ByVal value As String)
            _dispName = value
        End Set
    End Property
    Public Property ValueMember() As Integer
            Return _valMember
        End Get
        Set(ByVal value As Integer)
            _valMember = value
        End Set
    End Property
    Public Overrides Function ToString() As String
        Return _dispName
    End Function
End Class
Dim _MyList as MyList
    _MyList = New MyList("Canada",1001)
    _MyList = New MyList("California",1002)
    _MyList = New MyList("Sydney",1003)
    _MyList = New MyList("Melbourne",1004)

The value members 1001,1002,1003,1004 get inserted as per cbocity(combo box)display name selection , into the database and during the retrieval of the record the value member is obtained and based on that for eg:when i get 1001 the selected item should be Canada.I tried many ways while fetching the record and set the selected item but all fails . Please kindly help me in providing the solution.

Where is ur code to bind the records to combo? how ur setting the display and value member?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.