title: Insert Date And Time VB into Database Table
body: <p>I am using a DateTimePicker to select the date, and a TextBox that has the time.</p>
  
  <p>I am trying to insert both values into a table, but it does not work</p>
  
  <pre><code>INSERT INTO dt (date) VALUES('" &amp; DateTimePicker1.Text  &amp; TextBox1.Text &amp; "');
  </code></pre>
  
  <p>The <code>date</code> column is of <code>datetime</code> type.</p>
  
  <p>The code is showing this error : conversion failed when converting datetime from character string</p>