I wanted to fill the combo box with the data from my SQL server database.
There are two column in the table, product_id and product_name.
I was successful in displaying the product name in combo box. The code is given below. I wanted to show the product_name in the combo box and when the user selects the product_name from combo box i should be able to get its product_id. How do i do it? Please help me guys for my academic project.
Below is my code.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim conn As New System.Data.SqlClient.SqlConnection("Network Library=DBMSSOCN;" & "Data Source=abacus\mydatabase;" & "Initial Catalog=CADCAM2;" & "Integrated Security =True;" & "MultipleActiveResultSets=True;") Dim strSQL As String = "SELECT * FROM product" Dim da As New System.Data.SqlClient.SqlDataAdapter(strSQL, conn) Dim ds As New DataSet da.Fill(ds, "product") With Me.cmbDropDown .DataSource = ds.Tables("product") .DisplayMember = "product_name" .ValueMember = "product_id" .SelectedIndex = 0 End With end sub
Private Sub cmbCproduct_SelectedValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbCproduct.SelectedValueChanged 'when the user selects the product_name from the combo box i should be able to get the product_id. End Sub