This is a migrated thread and some comments may be shown as answers.

Databing with DateTime values

2 Answers 141 Views
Chart (Obsolete)
This is a migrated thread and some comments may be shown as answers.
Jonathan
Top achievements
Rank 1
Jonathan asked on 11 Aug 2008, 03:20 PM
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.

2 Answers, 1 is accepted

Sort by
0
Accepted
Ves
Telerik team
answered on 12 Aug 2008, 12:25 PM
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.
0
Jonathan
Top achievements
Rank 1
answered on 13 Aug 2008, 06:48 AM
Hi,

Thanks for the quick response, exactly what I wanted to know.
Tags
Chart (Obsolete)
Asked by
Jonathan
Top achievements
Rank 1
Answers by
Ves
Telerik team
Jonathan
Top achievements
Rank 1
Share this question
or