We cannot see how your are populating your DropDownList.
Generally, DropDownLists bound to a table need two informations: the key representing the selected value (a key because it must allow to retrieve a specific row in the table unambiguously), and the text used to display the selected value. These informations are controlled with
DataValueField
and
DataTextField
properties, respectively. So that when you select "Hex Mec" in the list, the value returned by the
SelectedValue
property is the primary key of the element in the database table.
You can see more on
DropDownList
usage on its reference page:
DropDownList Class[
^]
Kindly.