Use another SQL statement. Construct it like this-
Dim strSQL2 As String = "SELECT product_id FROM product where product_name=" & Me.cmbDropDown.SelectedItem
You can try online examination project.
Have done one here- http://dontnet.tekyt.info
button 1 is the update button. let me know if this helped you.
