Ok, I have been asking lots about this TimeZone issue but I think I have it mostly figured out.
All my data is now stored in the SQL database as UTC time. I am storing a string "Pacific Standard Time" for instance in the database for the company the user logs in as. Upon login I am thinking about saving in the session the string for the timezone so I can use it to convert all the dateTime values when they are displayed. I am also displaying on the pages the TimeZone used. Because creating a TimeZoneInfo object would generally be created by retrieving this from the registry and this is on a web server I have saved a TimeZone.xml file on the web server that has only the TimeZones I am interested in. TimeZoneInfo can be obtained with TimeZoneInfo.FromSerializedString("Pacific Standard Time") and this is what I will do.
My question is how should I save the TimeZoneInfo for the current user? Should I create it with the FromSerializedString with every page hit or would it be best to store the object in the session? I am not sure how big it is, and once in the users session I would save lots of time I would think.
Thanks for any thoughts.
Tim
Timothy Bryan