Skip to main content

Using dynamic data with Telerik RadPivotGrid

Using the Telerik RadPivotGrid is a great way to render out financial data such as balance sheets,  a UI can be knocked up very quickly:
The issue with this is you're required to use strongly typed entities (classes), what do I mean by this?

I mean the class being bound to the control has to have explicitly named properties which will be used for the columns and rows in the pivot grid. The 'Getting Started' pages on the Telerik website show how to use a collection of the following entity:
The binding is done in XAML:
As you can see the properties of the Name class are explicitly defined, this provider resource is then used as follows:
This gives you the following output:
I don't have a strongly typed entity, so what am I going to do?

What follows is a way to binding data with no structure, when I say no structure I mean the data is no more than name-value pairs or more commonly known as a dictionary\map.

I've split the metadata from the data - what I mean is the 'definition' of the columns & rows for the pivot grid are separated from the actual data to be bound:
Loading ....
As you can see the data is an array of dictionaries, and because this data has no explicit structure it can't be bound to the pivot grid. To get round this I need to do 2 things, firstly create a .Net type on the fly and secondly create a LocalDataSourceProvider configuration and bind this to the pivot grid.

Both tasks are relatively easy to do, the first uses System.Reflection.Emit namespace to create a .Net type at runtime which is then used to populate a collection used for binding to the pivot grid. What's interesting about this is I'm only using the type for binding to the pivot grid control - I'm not using it as any kind of Model (MVVM\MVC) so the type of the collection does not matter and therefore it can exposed as IEnumerable<object> on the ViewModel - I've only included the property for brevity:
Loading ....
Emitting the code is fairly easy, firstly creating TypeBuilder:
Loading ....
This is then used create the actual type, you can see I'm passing in the required property names & types - for my usage these can be either a string or a nullable decimal value:
Loading ....
I use these two methods as part of a service which processes the Definition & Data classes into the runtime .Net type - the type is called PivotItem:
Loading ....
I use the service inside the ViewModel to populate the PivotItems collection.

That's the first task complete.

The second task as I said is taking this collection and binding it to the pivot grid. I won't be able to use the declarative approach of XAML to do this now the .Net type is being created at runtime. Couple with the fact I'm using the MVVM pattern with a DataTemplateSelector to resolve DataTemplates in a View first approach, means I going to have to use a Behavior, this is setup as follows:
As you can see the Behavior has two dependency properties, one for the Definition class which contains X & Y axis information and the other the PivotItems collection. These are both used to dynamically create the required Telerik LocalDataSourceProvider class for binding to the control:
Loading ....

This will give you the output as shown at the start of the post.

The code is available for download:


Popular posts from this blog

Showing a message box from a ViewModel in MVVM

I was doing a code review with a client last week for a WPF app using MVVM and they asked ' How can I show a message from the ViewModel? '. What follows is how I would (and have) solved the problem in the past. When I hear the words ' show a message... ' I instantly think you mean show a transient modal message box that requires the user input before continuing ' with something else ' - once the user has interacted with the message box it will disappear. The following solution only applies to this scenario. The first solution is the easiest but is very wrong from a separation perspective. It violates the ideas behind the Model-View-Controller pattern because it places View concerns inside the ViewModel - the ViewModel now knows about the type of the View and specifically it knows how to show a message box window: The second approach addresses this concern by introducing the idea of messaging\events between the ViewModel and the View. In the example below

Implementing a busy indicator using a visual overlay in MVVM

This is a technique we use at work to lock the UI whilst some long running process is happening - preventing the user clicking on stuff whilst it's retrieving or rendering data. Now we could have done this by launching a child dialog window but that feels rather out of date and clumsy, we wanted a more modern pattern similar to the way <div> overlays are done on the web. Imagine we have the following simple WPF app and when 'Click' is pressed a busy waiting overlay is shown for the duration entered into the text box. What I'm interested in here is not the actual UI element of the busy indicator but how I go about getting this to show & hide from when using MVVM. The actual UI elements are the standard Busy Indicator coming from the WPF Toolkit : The XAML behind this window is very simple, the important part is the ViewHost. As you can see the ViewHost uses a ContentPresenter element which is bound to the view model, IMainViewModel, it contains 3 child v

Custom AuthorizationHandler for SignalR Hubs

How to implement IAuthorizationRequirement for SignalR in Asp.Net Core v5.0 Been battling this for a couple of days, and eventually ended up raising an issue on Asp.Net Core gitHub  to find the answer. Wanting to do some custom authorization on a SignalR Hub when the client makes a connection (Hub is created) and when an endpoint (Hub method) is called:  I was assuming I could use the same Policy for both class & method attributes, but it ain't so - not because you can't, because you need the signatures to be different. Method implementation has a resource type of HubInnovationContext: I assumed class implementation would have a resource type of HubConnectionContext - client connects etc... This isn't the case, it's infact of type DefaultHttpContext . For me I don't even need that, it can be removed completely  from the inheritence signature and override implementation. Only other thing to note, and this could be a biggy, is the ordering of the statements in th