I need to populate a drop down list with the text to be the name of 2 columns combined and the value of the text to be the unique ID column. So intVehicleID column (set as value) and LocationDescription + Vehicle columns (set as the text that corresponds with the intVehicleID). Right now my code looks like this but does not have the value set.
sql = "SELECT intVehicleID, LocationDescription, Vehicle FROM VehicleScheduler.dbo.tblVehicles ORDER BY LocationDescription"
myDataTable = New DataTable
myDataTable = getData(sql)
For Each DataRow In myDataTable.Rows
ddlShow.Items.Add(DataRow("LocationDescription") + " > " + DataRow("Vehicle"))