How to convert datetime UTC column to local time in datagridview?

Question

I am working on a new log database in which I decided to use UTC datetime to store all datetime values, since our company covers time intervals, and several sources and time zones are registration events. This works great.

However, a problem that I cannot figure out is the datetime formatting in my datagridview for my user application.

Our applications use LINQ to SQL mainly to process our data from common SQL CRUD calls, so I hope I can mask / format the DGV to get a transform or some LINQ function, instead of writing special SQL stored procedures this every time when I need to display data. (I found several sources that explain how to do this)

Thanks in advance. I tried to provide as much information as possible, but if I missed something, let me know.

I would like to get an answer in VB.NET, but C # works fine (this fully applies to both applications, it just happens in VB.BET)

Answer 1

RowCreatedEvent : TimeZoneInfo.ConvertTimeFromUtc

. Microsoft ( Vb, #):

http://msdn.microsoft.com/en-us/library/system.timezoneinfo.converttimefromutc.aspx