Home All Groups Group Topic Archive Search About

Sorting a filtering a generic list bound to a paged GridView?

Author
1 Feb 2007 8:30 AM
Harry Haller
Hello, I want to implement a generic list which will be used to
display 7 columns in a GridView. One should be able to sort, filter
and page each of the 7 columns. Ideally the filter should be
implemented simultaneously for multiple columns - but the data need
only be sorted by a single column at a time. Sorting should be both
ascending and descending.

I'm currently using a DataView but it's far too slow, because there
are a large number of rows. When full, there are about 2000 rows to
the DataView and 15 columns. None of the columns are particularly
long.

The filtering is done with 7 DropDownLists to which data is bound -
each of the dropdowns has a value and text display - for instance
ConsultantID, ConsultantName

The DataView looks like this:

TransactionID, ConsultantID, ConsultantName, ManagerID, ManagerName,
AssetClassCode, AssetClassName, ... etc.

The IDs are generally integers and the Codes - single or double
characters, only the Names are displayed in the GridView - the IDs and
Codes are there to speed up filtering.

I've seen some examples on the web.

Should I be following the methods that use delegates for the sorting?

Is FindAll() with a List<T> suitable for all the filtering?

Am I better off using a BindingList<T> rather than a List<T>

AddThis Social Bookmark Button