[Solved] Using GridViewExpressionColumn as a datasource.

[david mcintyre]

Is it possible to use a gridviewexpressioncolumn in a radgridview as a datasource for a series mapping in a bar chart?  My gridview is analogous to the one at http://demos.telerik.com/silverlight/#GridView/ExpressionColumn, and I want to chart the values in "total value in stock" in a bar chart, just like in http://demos.telerik.com/silverlight/#Chart/Gallery/Bar.  Is it possible to do this without repeating the calculation? 

Ideally, the bar chart would be updated whenever the inputs (price or qty)  were edited in the gridview as well. 

[Nikolay]

Hi David Mcintyre,

Could you, please, have a look at this example, which demonstrates a scenario that seems similar to yours and would perhaps be useful for you.

Greetings,
Nikolay
the Telerik team

[david mcintyre]

I don't see how the example at http://demos.telerik.com/silverlight/#Chart/EmptyValues is relevant to my needs.  In the "EmptyValues" example, the chart and the gridview are bound to a common viewmodel.  I don't want to bind the chart's dataseries to a VM, but to a calculated column that is in the gridview but not in the VM.  Are you saying that I need to move the expression from the gridview's codebehind and into the VM? 

[Tsvetie]

Hi David Mcintyre,
In short - no, it is not possible to bind the chart directly to a column in the gridview control. That is why, you should use another approach - e.g. move the expression to the VM, or to the SQL statement; add the datapoints to the series of the chart dynamically, etc. The best approach depends on your requirements and preferences.

All the best,
Tsvetie
the Telerik team