Multiple series from multiple tables

[mike]

Hi
Just wondering if there is some way of having each of my data series from a separate data table within a single dataset. I have tried creating two series, and then returning data from a database in two different tables (but within the same dataset), and the RadChart seems to ignore the second table completely. If all the data must be in a single table, this makes it extremely difficult to return the data as I need to dynamically create tables in SQL with different numbers of columns, and union all my data results into a single table, which also wastes a lot of bandwidth as I would have a lot of null value columns because each series of data must include nulls for all the values from the other series.
Thanks

[Ves]

Hi Mike,

I am afraid you cannot show data from different tables in RadChart using databinding. Still, you can create manually the series you need to show and add ChartSeriesItems to them according to the values in the different tables. You can find examples of programmatically created RadChart here and here (help topics) and in this online example.

Hope this helps.

Greetings,
Ves
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[mike]

Thanks, that workaround should do the trick.