I figured out what I was doing wrong with the datasource. I wasn't selecting an ID and binding to it and it couldn't bind to the text.
>I still want to know if I can bind directly to a SQL Datasource, but I tried to bind using the way in the zip file and that doesn't work either. It seems as if it is pulling the values for the x series, but I can only see one and a half of them and there is no data being displayed in the column.
I've attached the code behind. The stored procedure spQ_MarketingCounts returns 2 columns- MarketingSource which has a list of sources for marketing and MarketingCounts which is the count for each source.
>That's doing everything in the code behind. Is it possible to bind to the chart using a SqlDatasource:
< a s p:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:connStr %>"
SelectCommand="spQ_MarketingCounts" SelectCommandType="StoredProcedure">
>Hi Melissa,
Thanks for using Syncfusion products.
Here is the sample, which explains:
1. Connecting SqlDataBase with Chart using ConnectionString.
2. Object for ChartDataBindModel is created to access the DataTable.
3. Assigning fields to X and Y Axis.
4. Setting the labels.
And then appearance can be changed as you like.
I hope this sample will help you.
Let me know if you have any more queries.
Thanks,
Sureshbabu
ChartDataBinding.zipMarketingCounts.ascx.zip