Is there a way to refresh the items currently in a listview control so that it shows only the top N rows? I have a listview control in a VB form that shows customer data for a particular salesperson. I've configured the listbox so that it can be sorted by a variety of column values. I would like to introduce functionality so that the salesperson can show all of their customers or only the top N customers.
I really cannot modify the SQL select statement as it's pulling various totals for different values. So saying something like "Select Top 10..." really won't work in this specific instance.
I'm hoping that someone can help me out with this.