<div>
thanks, but how do I get the valuemember and not the displaymember calling the contents. &nbsp;I am using ComboBox5.text but I am getting Pass instead of 1 (the value member) Thanks
</div>


thanks, but how do I get the valuemember and not the displaymember calling the contents.  I am using ComboBox5.text but I am getting Pass instead of 1 (the value member) Thanks

<div>
running32,<br />
<br />
You use ComboBox5.SelectedValue to return the valuemember associated with the item.<br />
<br />
Tim
</div>


running32,

You use ComboBox5.SelectedValue to return the valuemember associated with the item.

Tim

<div>
<div class="content wysiwyg-content">
In the code below I wanted to display the strAssistanceDesc in the combo box but have the lngAssistanceid as the value that is reterived. &nbsp;this code is displaying 1 which is the lngAssitanceid, how can I get it to display the name instead.<br />
<br />
thank you<br />
<br />
Dim cmd6 As New SqlClient.SqlCommand(&quot;Sele<wbr />ct * from tbllkpMHCPAssistance&quot;, Connection1)<br />
&nbsp; &nbsp; &nbsp; &nbsp; Try<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd6.ExecuteNonQuery()<br />
&nbsp; &nbsp; &nbsp; &nbsp; Catch ex As Exception<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MsgBox(ex.Message)<br />
&nbsp; &nbsp; &nbsp; &nbsp; End Try<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim da As New SqlDataAdapter(cmd6)<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim ds As New DataSet<br />
&nbsp; &nbsp; &nbsp; &nbsp; da.Fill(ds, &quot;tbllkpMHCPAssistance&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; me.ComboBox5.DataSource = ds.Tables(&quot;tbllkpMHCPAssis<wbr />tance&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me.ComboBox5.DisplayMember<wbr /> = &quot;strAsstistanceDesc&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me.ComboBox5.ValueMember = &quot;lngAssistanceid&quot;
</div>
</div>


In the code below I wanted to display the strAssistanceDesc in the combo box but have the lngAssistanceid as the value that is reterived.  this code is displaying 1 which is the lngAssitanceid, how can I get it to display the name instead.

thank you

Dim cmd6 As New SqlClient.SqlCommand("Select * from tbllkpMHCPAssistance", Connection1)
        Try
            cmd6.ExecuteNonQuery()
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
        Dim da As New SqlDataAdapter(cmd6)
        Dim ds As New DataSet
        da.Fill(ds, "tbllkpMHCPAssistance")
        me.ComboBox5.DataSource = ds.Tables("tbllkpMHCPAssistance")
        Me.ComboBox5.DisplayMember = "strAsstistanceDesc"
        Me.ComboBox5.ValueMember = "lngAssistanceid"

Displaying value member

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,