title: Vb.net to mySQL datetime conversion
body: <p>Hi i have this code and it give me error:</p>
  
  <blockquote>
    <p>Type of value has a mismatch with column typeCouldn't store &lt;10/1/2012
    3:43:30 PM> in time_in_am Column.  Expected type is MySqlDateTime.</p>
  </blockquote>
  
  <p>my mySQL data type for "time_in_am" is DateTime.</p>
  
  <pre><code>dataRow = dataSet.Tables(0).NewRow()
  dataRow("time_in_am") = DateTime.Now
  dataSet.Tables(0).Rows.Add(dataRow)
  </code></pre>