render a DateTime column in local time, not in UTC

[Alex]

Hi,

I want to display a column with DateTime objects in it. But if I try to set the format string either to

col.StyleInfo.Format = CultureInfo.CurrentCulture.DateTimeFormat.FullDateTimePattern ;
or to
col.StyleInfo.Format = "dd.MM.yy - HH:mm:ss";
all the times are displayed as UTC. How can I tell the StyleInfo to use the local timezone? Otherwise it would be a great deal to convert all the table entries manual.

Thanks in advance,

Alex.

[Administrator]

So, the dates are displayed in the proper format, it is just that the time is the wrong value.

If this is a readonly grid, then you could use the grid.DrawCelDisplayText event. There you can get the DateTime object from the style.CellValue. Then call the ToLocalTime() method on this DateTime object to convert it from UTC to local. Then you can format the converted object, and set the formatted string into e.Text.

If it is not a ReadOnly grud, then you would have to use the QueryCellFormattedText and SaveCellFormattedText events to flip the time from UTC to local in QueryCellFromattedText and then from local to UTC in SaveCellFormattedText.

DateTime d;
d.ToLocalTime();