title: Display DateTime data in users TimeZone in DataTable
body: <p>We have a reporting application where all DateTimes are stored in UTC in the database (SQL server 2005)</p>
  
  <p>The reporting application works simply be retrieving a DataTable and binding to a DataGrid displaying the information.</p>
  
  <p>If we know the logged in users time zone (e.g. +3 GMT), is there any way to update the DataTables dates which are in UTC to now display in the users time zone?</p>
  
  <p>We know we can spool thorugh each column/row in the DataTable and do a conversion but is there a better more efficient way?</p>