problem regarding Date on X-Axis

[Albert]

How do I place a date on x using this.

this.DataManager.ValuesXColumn  = "Date"

And no, I cannot preconvert it using SQL and no I cannot use the .ToDateOA command. I can only use a reference to the column name.

[Vladimir Milev]

Hello Albert,

Using the ToOADate method is the only way to convert a DateTime class instance to a double precision floating point number. Since there is no support for this conversion out of the box I am afraid this is your only option. Check the ItemDataBound event - there you can convert DateTime values to double values and set them to your XValues manually.

Regards,
Vladimir Milev

[Stefan Willebrand]

How can I access the dates in ItemDataBound to convert them? Can you give me a code example?

[Ves]

Hello Stefan,

Here is an example:

void RadChart1_ItemDataBound(object sender, Telerik.Charting.ChartItemDataBoundEventArgs e)
    {
        if (e.SeriesItem != null)
        {
            e.SeriesItem.XValue = Convert.ToDateTime(((DataRowView)e.DataItem)["Date"]).ToOADate();
        }
    }

Hope this helps.

Kind regards,
Ves
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.