Xceed Community - Filtering in Xceed Datagrid using RemoteListDataSource

sales.europe@xceed.com

support.europe@xceed.com

Welcome to the Xceed Community | Help

Community Search
More Search Options

Xceed Community » WPF and Silverlight Controls » Xceed DataGrid for Silverlight » Re: Filtering in Xceed Datagrid using RemoteListDataSource

Filtering in Xceed Datagrid using RemoteListDataSource


	Sort Posts: Previous Next

01-17-2012, 8:35 AM Post no. 31572

Rajat
Joined on 01-17-2012
Posts 2

Filtering in Xceed Datagrid using RemoteListDataSource

Hello,

I am using RemoteListDataSource to bind the data with xceed silverlight datagrid, sorting is working, grouping is also working but when i am using the filtering option with :

<sldg:DataGridControl.FixedHeaders>

<sldg:FilterRow >

</sldg:FilterRow>

</sldg:DataGridControl.FixedHeaders>

The grid is not showing the template values(Equal, Not Equal, Greater Then, etc) for filtering.

Is that the limitation with remote data source or you have any other way to show filtering options.

If the filtering is possible then please tell me the way and if not then please let me know the exact reasons.

Quick answer will be appreciated as I have stucked at the part.

Thanks in advance.

With Regards,

Rajat Barik

Report abuse

01-24-2012, 9:16 PM Post no. 31603 in reply to 31572

Michel [Xceed]
Joined on 04-26-2010
Posts 417

Re: Filtering in Xceed Datagrid using RemoteListDataSource

Since you are using a remove data source, then most of the filtering should occur on the server side in order to avoid possible massive performance problems.
Ex.
ShipCountry == Mexico

If this expression is not processed server side, and this case occur about 1 time on 10 000 items, you will end up downloading about 300 000 items to display the content of a single page of 30 rows.

An exemple of a remote data source supporting server-side filtering is the SqlDataSource. This data source would probably be more close to your user's needs. Using a WCF Data Service on your server side would also do the job.

If the performance impact of doing filtering on the client-side does not apply to your case, an option would be to use the "DataGridControl.Filter" event and to do your own filtering locally. In this case, the FilterRow cannot be used and a custom UI based on your user's filtering options needs would have to be developed.

Best Regards,

Michel Dahdah
Technical Support
Xceed Software inc.

Report abuse