HTML CHART

[Riccardo]

Hello,

 

I am getting glitches trying to 

connect AdventureWorks2012 db to Telerik UI webapp.

How can I connect some data to a chart?

I m readin the tutorials, but now sure how to synch

then grab data and drop evrything in the chart.

[Vessy]

Hi Riccardo,

In order to bind the chart, you have to configure its data filed-related properties (with the names of te columns holding the data) and set the Datasource / Datasource Id of the control.

For example, in an SqlLDataSource scenario, the chart's declaration can look in a similar way:
https://docs.telerik.com/devtools/aspnet-ajax/controls/htmlchart/data-binding/sqldatasource

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TelerikConnectionString %>"
    SelectCommand="SELECT [Year], [Value] FROM [Data] WHERE ([Subcategory_Id] = 1)">
</asp:SqlDataSource>
<telerik:RadHtmlChart runat="server" ID="RadHtmlChart1" DataSourceID="SqlDataSource1">
    <PlotArea>
        <Series>
            <telerik:ColumnSeries DataFieldY="Value" Name="Electricity Consumption">
            </telerik:ColumnSeries>
        </Series>
        <XAxis DataLabelsField="Year">
            <LabelsAppearance RotationAngle="75" />
            <TitleAppearance Text="Year" />
        </XAxis>
        <YAxis>
            <TitleAppearance Text="MWh" />
        </YAxis>
    </PlotArea>
    <Legend>
        <Appearance Visible="false" />
    </Legend>
    <ChartTitle Text="Electricity Consumption">
    </ChartTitle>
</telerik:RadHtmlChart>

Regards,
Vessy
Progress Telerik