Using asp.net, I have a dropdownlist with list of destinations. these are used to send a query to a mysql database. However, I was informed that other data will have destination codes instead of the actual destination name, so for instance, the column for destination in the database will have records with the name Manchester while others will have the code MAN. So at the moment, I have a limitation in the the asp.net form - I can only query the destination name so records with the code will not be resturned. below in the form and as you can see, it only has the name.
Is there a way in the form to make it query both the name and the code? without changing the database and also using the dropdown list
<asp:DropDownList id="departurepoint" runat="server">
<asp:ListItem Selected="True">Select a Destination</asp:ListItem>
Thanks in advance