This is my first time trying out RadChart. I have a very simple chart (that followed the example in the documentation section):
The code behind does a simple database query:
If I execute that line in the database, I get 30 rows back. However, when the chart is created, I only have the first 8 items shown, labeled 0 through 7. Why are the others missing, and how can I get the actually dates to be displayed?
<telerik:RadChart ID="RadChart1" runat="server" DefaultType="Line" />The code behind does a simple database query:
SqlDataSource sqlDataSource = new SqlDataSource();sqlDataSource.ID = "myDataSource";sqlDataSource.ConnectionString = "<snip>";sqlDataSource.SelectCommand = "select convert(varchar(10),SearchDate,101) as SearchDate, AverageSoldPrice from SearchResult where SearchId = 1 order by SearchDate";this.Page.Controls.Add(sqlDataSource);RadChart1.DataSourceID = "myDataSource";RadChart1.Series[0].DataYColumn = "AverageSoldPrice";RadChart1.PlotArea.XAxis.DataLabelsColumn = "SearchDate";RadChart1.DataBind();If I execute that line in the database, I get 30 rows back. However, when the chart is created, I only have the first 8 items shown, labeled 0 through 7. Why are the others missing, and how can I get the actually dates to be displayed?