title: SqlDataAdapter Truncates DateTime to 2 Digit Year
body: <p>I have a SQL table that I am trying to read into my application, which contains a datetime column. When I fill a DataTable using SqlDataAdapter in my application, it is truncating the year to a 2-digit year (so 1/1/1999 or 1/1/2099 both show 1/1/99).</p>
  
  <pre><code>Dim dt As DataTable
  Using connection As New SqlConnection("...")
      Dim query As String = "SELECT * FROM [foo]"
      Dim adapter As New SqlDataAdapter(query, connection)
  
      connection.Open()
      adapter.Fill(dt)
  End Using
  </code></pre>
  
  <p>Performing the same SELECT statement directly in SQL returns a datetime with a 4-digit year, so it seems like a VB problem and not a SQL problem.</p>
  
  <p>How can I make sure it reads the full year and avoid a Y2K-like bug?</p>