Hi,
I cant seem to see an answer to this question - is it possible to databind a DataSet to the RadChart when my XAxis plots DateTime values and the YAxis plots double values? All I can see if that if plotting DateTime values, you have to convert to OA Date format which seems to suggest you cannot use databinding.
Please could you confirm.
Thanks.
I cant seem to see an answer to this question - is it possible to databind a DataSet to the RadChart when my XAxis plots DateTime values and the YAxis plots double values? All I can see if that if plotting DateTime values, you have to convert to OA Date format which seems to suggest you cannot use databinding.
Please could you confirm.
Thanks.
2 Answers, 1 is accepted
0
Accepted
Hello Jonathan,
Indeed, RadChart does not support DateTime values directly. Still, as you have correctly noticed, you can use the OLE Automation equivalent. Here is an example of a sql query, which will convert the DateTime values to their OLE automation equivalents:
"SELECT [Temperature], CAST([Date] AS FLOAT) + 2 as float_date FROM [Table_1]"
Hope this helps.
Sincerely,
Ves
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Indeed, RadChart does not support DateTime values directly. Still, as you have correctly noticed, you can use the OLE Automation equivalent. Here is an example of a sql query, which will convert the DateTime values to their OLE automation equivalents:
"SELECT [Temperature], CAST([Date] AS FLOAT) + 2 as float_date FROM [Table_1]"
Hope this helps.
Sincerely,
Ves
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Jonathan
Top achievements
Rank 1
Rank 1
answered on 13 Aug 2008, 06:48 AM
Hi,
Thanks for the quick response, exactly what I wanted to know.
Thanks for the quick response, exactly what I wanted to know.