I have a database, which I query, and I'm unsure of where to perform the sorting of the results, so far I've have the following options.
The List is composed by ObjectDTO so where would it be more efficient. Any ideas?
Method A: Sort button in Home tab In the Editing group under Home tab, you will easily get the Sort & Filter button. Click the drop down button besides Sort & Filter button, and then you will get more sorting options: Sort A to Z, Sort Z to A, and Custom Sort.
Select any cell in the data range. On the Data tab, in the Sort & Filter group, click Sort. In the Sort dialog box, under Column, in the Sort by box, select the first column that you want to sort. Under Sort On, select the type of sort.
To focus on a specific set of your data, you can filter a range of cells or a table. Click any cell in the range or table. On the HOME tab, click Sort & Filter, and click Filter.
Database. Using indexes and other information about the data, db's are very good at this.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With