title: DateTime region specific formatting in WPF ListView
body: <p>In WPF app I have a ListView:</p>
  
  <pre><code>&lt;ListView Height="100" Width="434" Margin="0,2,0,0" x:Name="lvItems" ItemsSource="{Binding ElementName=MainWindow, Path=ShowQuCollection}" &gt;
    &lt;ListView.View&gt;
      &lt;GridView&gt;
       &lt;GridViewColumn Header="Date" Width="100" DisplayMemberBinding="{Binding Date}"/&gt;
       &lt;GridViewColumn Header="Time" Width="100" DisplayMemberBinding="{Binding Time}"/&gt;
       &lt;GridViewColumn Header="Description" Width="200" DisplayMemberBinding="{Binding Description}"/&gt;
      &lt;/GridView&gt;
     &lt;/ListView.View&gt;
   &lt;/ListView&gt;
  </code></pre>
  
  <p>which is connected with ObservableCollection through databinding. ObservableCollection is populated from SQLServer db table using LINQ to SQL.</p>
  
  <pre><code>ObservableCollection&lt;ShowsQu&gt; _ShowQuCollection =
          new ObservableCollection&lt;ShowsQu&gt;();
  
  public ObservableCollection&lt;ShowsQu&gt; ShowQuCollection
  { get { return _ShowQuCollection; } }
  
  public class ShowsQu
  {
      public string ShowCode { get; set; }
      public DateTime Date { get; set; }
      public TimeSpan Time { get; set; }
      public string Description { get; set; }
  }
  
  private void VisualizeAllShows()
  {
  
      MyfirstdbDataContext context = new MyfirstdbDataContext();
      _ShowQuCollection.Clear();
  
      var sh = from p in context.Shows select p;
  
      foreach (var p in sh)  
        _ShowCollection.Add(new ShowsQu
          {
              Date = p.Date,
              Time = p.Time,
              Description = p.Description
          });                 
  }
  </code></pre>
  
  <p>The problem is that ListView displays a Date field from SQLServer database table as it is - without applying region specific formatting (I guessed it should be applied by default).</p>
  
  <p>Where and what should I do to get it be formatted the way as PC regions settings are?</p>