I saw some examples with binding gantt chart to daterange:
RadChart1.PlotArea.YAxis.AddRange((new DateTime(2007, 1, 1)).ToOADate(), (new DateTime(2008, 1, 1)).ToOADate(), ((new DateTime(2008, 1, 1)).ToOADate() - (new DateTime(2007, 1, 1)).ToOADate()) / 7);
How can I bind that to sqldatasource with 2 fields "DateStart" and "DateEnd"?
Thanks
RadChart1.PlotArea.YAxis.AddRange((new DateTime(2007, 1, 1)).ToOADate(), (new DateTime(2008, 1, 1)).ToOADate(), ((new DateTime(2008, 1, 1)).ToOADate() - (new DateTime(2007, 1, 1)).ToOADate()) / 7);
How can I bind that to sqldatasource with 2 fields "DateStart" and "DateEnd"?
Thanks
1 Answer, 1 is accepted
0
Hello John Ngo,
ToOADate is used, because RadChart does not have intrinsic support for DateTime values. In rder to get the data in suitable format you can use a select statement similar to this one:
SELECT (Cast MyDate AS FLOAT) + 2 AS MyFloatDate
Now, MyFloatDate will be float and the values will be the OLE Automation equivalents of the database dates. Hope this helps.
Greetings,
Ves
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
ToOADate is used, because RadChart does not have intrinsic support for DateTime values. In rder to get the data in suitable format you can use a select statement similar to this one:
SELECT (Cast MyDate AS FLOAT) + 2 AS MyFloatDate
Now, MyFloatDate will be float and the values will be the OLE Automation equivalents of the database dates. Hope this helps.
Greetings,
Ves
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.