Datasource question

Thread is closed for posting
2 posts, 0 answers
  1. Warren
    Warren avatar
    61 posts
    Member since:
    Aug 2013

    Posted 19 Aug 2013 Link to this post

    Hello,

    I am new to using the chart and was looking at the demos. On one of them they are using a SQLDataSource control using a select statement to select the x/y series data. It looked like the fields selected are being used in the series code to define the data fields. My question is if I use a stored procedure that returns many extra fields can I still use it and only set the fields I want for the series part? In other words if I have fields Sales, ID, Person, Address, City returned and I only want to use Sales and Person can I do this and it will ignore the other fields being returned?

    Thanks!

    Warren
  2. Ves
    Admin
    Ves avatar
    2879 posts

    Posted 22 Aug 2013 Link to this post

    Hi Warren,

    Sure, you can use an existing stored procedure as long as it provides the necessary data. Having more columns will not hurt. Make sure that you populate correctly the ChartSeries' properties that define ChartSeriesItems' values -- DataLabelsColumn, DataXColumn, DataYColumn, DataXColumn2, DataYColumn2, DataYColumn3 and DataYColumn4 (use only those that are relevant for your series).

    As a side note, RadChart is not in active development and for new development we recommend using our RadHtmlChart. You can find a detailed comparison here.

    Best regards,
    Ves
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top