SortExpression with Actual displayed values not working
<p>I have an ASP.NET application in which I have a Gridview displayed bound to an SqlDataSource. The columns within the gridview contain fields Item_ID (PK), Country_ID, Period_ID, Description. The Country_ID is foreign keys relating to other tables containing a list of country names. I have converted these columns to template fields containing dropdown lists showing the actual country names databound to the corresponding foreign key ID fields. When I click on the column headers for Country forsorting, the gridview will sort records based on the foreign key ID values, not the actual text values as shown in the grid view. How do I go about getting the sort to apply to the related text values, not the ID values?</p>
