How to Implement the User-Defined Function for sorting and querying Columns

This evening, I was still thinking about how to select the data columns and sorting methods displayed on the query page, which is similar to windows. The column query function is easy to implement. You only need to modify the page control, but the sorting function is still difficult to implement, because all the data is unsorted from the underlying query, it cannot meet the requirement if it is directly bound to the WebGrid. Occasionally, it is found that using DataView as an intermediary to filter and sort data is a good method, so that no changes need to be made to the underlying layer, you can also modify the implementation method of the control, and finally find a good solution to these two problems.