I'm curious as to the best route (more looking towards simplicity, not speed or efficiency) to sort a DropDownList in C#/ASP.NET - I've looked at a few recommendations but they aren't clicking well with me.
Edit: Folks, I do not have control over how the data comes into the DropDownList - I cannot modify the SQL.
If you get a DataTable with the data, you can create a DataView off of this and then bind the drop down list to that. Your code would look something like...
DataView dvOptions = new DataView(DataTableWithOptions); dvOptions.Sort = "Description"; ddlOptions.DataSource = dvOptions; ddlOptions.DataTextField = "Description"; ddlOptions.DataValueField = "Id"; ddlOptions.DataBind();
Your text field and value field options are mapped to the appropriate columnns in the data table you are receiving.