This question is locked. New answers and comments are not allowed.
Hi
I am using Entity Framework 4 and RIA service to retrieving the data from the database and transfer it to client
after using the newest release version of RadGridView Q1 2011, i do know that the current version will make all of the Sorting/Grouping/Filtering through SERVER side by clicking on the corresponding column header.
However, i have a problem with that because my collection has some EXTRA properties which have been created on the fly during retrieving data from the database , and then that collection will be bounded to the itemsSource of RadGridView
For example, I have a table Order with the fields:
OrderId, CustomerId, Description
(foreign key to Customer table)
because our Customer table will have thousand of records and we don't really want to show the CustomerId but instead we want to show the CustomerName on the radGridView (using GridViewComboxColumn isn't a solution because of large data). In order to be able to accomplish that, I have created an extra property CustomerName for the Order object
-now the Order object will have the fields (BUT IN THE DATABASE, it will only have OrderId, CustomerId, Description)
OrderId, CustomerId, CustomerName, Description
(corresponding to the CustomerId)
And now i encounter the problem of sorting/grouping/filtering for the CustomerName on the radgridview. Whenever i click on the CustomerName to do the sorting/grouping/filtering, it will always fail because that's customerName not really existing in the database ORDER table (due to default server-side sorting/grouping/filtering)
1. By doing further research in the forum, i find out that i can use the SortMemberPath/GroupMemberPath. So for the CustomerName column , i set SortMemberPath/GroupMemberPath to CustomerId in order to fix the issue. It works PARTLY. What i mean is that, if i do the grouping , then the groupLable will show CUSTOMERID (but i want it to show CUSTOMERNAME) for each group.
--->The best solution i can think of how to fix my current problem is to change the default sorting/grouping/filtering to CLIENT side (instead of Server side). With that i think that might fix my current problem. But i don't know how to set that???
---> Or override the sorting/grouping/filtering to let it work with CustomerName on the serverside but how ???
plz help me. Any sample code or articles will be appreciated
thanks
I am using Entity Framework 4 and RIA service to retrieving the data from the database and transfer it to client
after using the newest release version of RadGridView Q1 2011, i do know that the current version will make all of the Sorting/Grouping/Filtering through SERVER side by clicking on the corresponding column header.
However, i have a problem with that because my collection has some EXTRA properties which have been created on the fly during retrieving data from the database , and then that collection will be bounded to the itemsSource of RadGridView
For example, I have a table Order with the fields:
OrderId, CustomerId, Description
(foreign key to Customer table)
because our Customer table will have thousand of records and we don't really want to show the CustomerId but instead we want to show the CustomerName on the radGridView (using GridViewComboxColumn isn't a solution because of large data). In order to be able to accomplish that, I have created an extra property CustomerName for the Order object
-now the Order object will have the fields (BUT IN THE DATABASE, it will only have OrderId, CustomerId, Description)
OrderId, CustomerId, CustomerName, Description
(corresponding to the CustomerId)
And now i encounter the problem of sorting/grouping/filtering for the CustomerName on the radgridview. Whenever i click on the CustomerName to do the sorting/grouping/filtering, it will always fail because that's customerName not really existing in the database ORDER table (due to default server-side sorting/grouping/filtering)
1. By doing further research in the forum, i find out that i can use the SortMemberPath/GroupMemberPath. So for the CustomerName column , i set SortMemberPath/GroupMemberPath to CustomerId in order to fix the issue. It works PARTLY. What i mean is that, if i do the grouping , then the groupLable will show CUSTOMERID (but i want it to show CUSTOMERNAME) for each group.
--->The best solution i can think of how to fix my current problem is to change the default sorting/grouping/filtering to CLIENT side (instead of Server side). With that i think that might fix my current problem. But i don't know how to set that???
---> Or override the sorting/grouping/filtering to let it work with CustomerName on the serverside but how ???
plz help me. Any sample code or articles will be appreciated
thanks