Connecting Tech Pros Worldwide Forums | Help | Site Map

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

Harry Haller
Guest
 
Posts: n/a
#1: Feb 1 '07
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<Tsuitable for all the filtering?

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

RobinS
Guest
 
Posts: n/a
#2: Feb 1 '07

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


Are you talking about GridView or DataGridView? VB or C#? WebForms or
Windows FOrms? .Net 2.0 or .Net 1.1?

Robin S.
------------------------------
"Harry Haller" <Harry@Steppenwolf.comwrote in message
news:9gciu29t1p23vhvpn9dl2bklkprb2lkndn@4ax.com...
Quote:
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<Tsuitable for all the filtering?
>
Am I better off using a BindingList<Trather than a List<T>

mark4asp
Guest
 
Posts: n/a
#3: Feb 1 '07

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


On Thu, 1 Feb 2007 00:59:34 -0800, "RobinS" <RobinS@NoSpam.yah.none>
wrote:
Quote:
>Are you talking about GridView or DataGridView? VB or C#? WebForms or
>Windows FOrms? .Net 2.0 or .Net 1.1?
GridView with ASP.NET 2.0

Even when I run my DataView version locally it's taking 15 seconds to
complete the page, much longer when it's run over the web.
Quote:
>Robin S.
>------------------------------
>"Harry Haller" <Harry@Steppenwolf.comwrote in message
>news:9gciu29t1p23vhvpn9dl2bklkprb2lkndn@4ax.com.. .
Quote:
>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<Tsuitable for all the filtering?
>>
>Am I better off using a BindingList<Trather than a List<T>
>
RobinS
Guest
 
Posts: n/a
#4: Feb 1 '07

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


I don't do web stuff, I do windows forms. Brian Noyes wrote a Data Binding
book, and tells how to do sorting and filtering on a DataGridView in
WinForms on a list of business objects. If you think that would help you,
check out his book. He also has the sample code online at
http://softinsight.com/databindingbook. Check out Chapter 9, Customer
Business Objects.

He also has some info about web forms in his book, but since I don't do web
stuff, I didn't read it that closely.

Hope this helps.

Robin S.
Ts'i mahnu uterna ot twan ot geifur hingts uto.
---------------------------------------
"mark4asp" <mark4asp@gmail.comwrote in message
news:i3k3s2t44eqsa7nu8cl1g4shnoremto6b2@4ax.com...
Quote:
On Thu, 1 Feb 2007 00:59:34 -0800, "RobinS" <RobinS@NoSpam.yah.none>
wrote:
>
Quote:
>>Are you talking about GridView or DataGridView? VB or C#? WebForms or
>>Windows FOrms? .Net 2.0 or .Net 1.1?
>
GridView with ASP.NET 2.0
>
Even when I run my DataView version locally it's taking 15 seconds to
complete the page, much longer when it's run over the web.
>
Quote:
>>Robin S.
>>------------------------------
>>"Harry Haller" <Harry@Steppenwolf.comwrote in message
>>news:9gciu29t1p23vhvpn9dl2bklkprb2lkndn@4ax.com. ..
Quote:
>>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<Tsuitable for all the filtering?
>>>
>>Am I better off using a BindingList<Trather than a List<T>
>>
>

Closed Thread