Combo display & value [RESOLVED]

[carlblanchard]

Hi All

Ive got a combo box which is being filled by a dataset i want to show the text value from one column but when a user makes their selection i want to pass over the datasets record Id rather than the text value (How is this done)

Heres the vb code for filling the combo

Private Sub Designer_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim objData As New NewForestMortgagesAPP.DesignerDI.GetDI
        Me.cboLetter.DisplayMember = "LetterName"
        Me.cboLetter.DataSource = objData.GetDataSet.Tables(0)
    End Sub

I just wana know the correct way of doing this ?

Many Thanks

[Memnoch1207]

try something like this

Dim objData As New NewForestMortgagesAPP.DesignerDI.GetDI
        
Me.cboLetter.DataSource = objData.GetDataSet.Tables(0)
Me.cboLetter.DataValueField = "RecordId" 
Me.cboLetter.DataTextField = "LetterName"
Me.cboLetter.DataBind()

[carlblanchard]

is that for asp.net because theres no such property of DataValueField within a win form combo box

[Edneeis]

You would do like Memnoch1207 showed only the Property should be "ValueMember" and then to get the value use the SelectedValue property instead of the Text property.

[carlblanchard]

Yep i done it with ValueMember = "ColumnName"
I was trying to get the value by using ValueMember as well (when its simply SelectedValue that returns the correct ID )

I must say ( this method of binding to control ) is absolutly wicked.

My Code is looking cleaner and more understandable every single day Thanks All