I'm creating a GridView that displays the details of an order. One of the columns shows which Location the order went to. All the information is correctly displayed and is based on a single SQL query (SqlDataSource1).
When they edit the item, I have another SQL query (SqlDataSource2) that correctly pulls a list of all the customer's locations and populates a DropDownList. The issue I'm having is trying to set the SelectedValue of the DropDownList to the Location value, which is pulled in the first SQL query.
Here's what I've been working with so far...