WebDataGrid Columns with Dropdown Editors should sort on the "text" value
WebDataGrid columns with Dropdown Editors and:
Value = ID (Primary and/or Foreign Key)
Text = Description or other meaningful identifier
should sort on the Text value displayed to the user and not the ID value stored in the database.
For instance a Project table might contain:
ProjectID = 1234 (Primary and\or Foreign Key stored in the database record)
ProjectNumber = "O7BP201W" (user friendly identifier)
ProjectNumber = "A9RI105R"
ProjectNumber = "C4XQ921V"
The user sees the Project Number, but when sorting it sorts on the ID which is meaningless as the above would never sort as the user wants to see it.