[Solved] Specifying an indexed field/property for a series column

[John]

I was unable to bind a DataTable to my MVC Chart control, so I converted the DataTable into an IEnumerable<Dictionary<string,object>> class.  I am able to bind it to my chart now; however, I am unable to specify the value column for an indexed property!

@(Html.Telerik().Chart(Model)
   .Name("chart")
   .Series(series => {
           series.Bar<string>(s => (string)s["Col1"]).Name("Representative Sales");
   })
   .CategoryAxis(axis => axis
       .Categories(s => s.Count)
   ))

I get the error:

Bound columns require a field or property access expression.

Basically, I am stuck.  How do I bind a DataTable to my MVC Chart control?  If that is not possible, then how do I specify an indexed property of a dictionary that I have converted the DataTable to, in order to bind it to the Chart control!? 

[Hristo Germanov]

Hi Joh,

The chart does not support data table binding and I am not sure that you can bind it with Dictionary<string,object> too. Can you try to bind the chart with List of objects?

All the best,
Hristo Germanov
the Telerik team

[Viktor]

Please send example.

Thank you,

[Hristo Germanov]

Hello John,

Could you please examine the attached project and tell me if it works for you.

Regards,
Hristo Germanov
the Telerik team

[John]

Your example has a class in it that knows the property names ahead of time.  The problem is that I will not know this information at design time since the data is coming from a stored procedure that the user specifies on his database.  Therefore, you are able to specify one of these properties for the value/category, but I am unable to do that because I won't know them at compile time.

[Hristo Germanov]

Hi John,

Can you examine this forum post and tell me if it works for you?

Regards,
Hristo Germanov
the Telerik team