title: VB.NET: showing DATE in datagridview bound in a database error
body: <p>I bind table A from mySQL database to a datagridview. One of its columns is "in_Date" with data type DATE(). An exception says</p>
  
  <blockquote>
    <p>String was not recognized as valid DateTime.Couldn't &lt;> store in
    in_Date column. Expected type is DateTime. </p>
  </blockquote>
  
  <p>Here's my code in connection: </p>
  
  <pre><code>Dim myconn as MySqlConnection = New MySqlConnection
  myconn.ConnectionString = "server=localhost; userid=root; password=pw; database=db"
  Dim adapter As MySqlDataAdapter = New MySqlAdapter 
  Dim table As DataTable = New DataTable
  Dim bind As New BindingSource 
  myconn.Open()
  Dim command as MySqlCommand ("select * from db.A;")
  adapter.SelectCommand = command 
  adapter.Fill(table) 
  bind.DataSource = table 
  MyDGV.DataSource = bind 
  adapter.Update(table)
  myConn.close() 
  </code></pre>
  
  <p>The table is yet empty. It was fine before when my columns are only in either varchar or int data types. How can I do that with DATE? I don't know what is the problem and how I can solve it. Thank you in advance. </p>