H
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>
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>