title: date time conversion problem when inserting data into sql database
body: <p>I used to query:</p>
  
  <pre><code>Dim a As String
  a = "INSERT INTO tblVisitor(Name, Sex, TimeIn, EnterDate)
       VALUES('"&amp; txtName.Text &amp;"', '"&amp; cboSex.Text &amp;"', '"&amp; Now() &amp;"', '"&amp; DateTime.Parse(cboEnterDate.Text) &amp;"')"
  
  myCommand = New SqlCommand(a, myConnection)
  myCommand.ExecuteNonQuery()
  ........................................
  </code></pre>
  
  <p>Which cboEnterDate is my DateTime Picker. Then I got the message:</p>
  
  <pre><code>Conversion failed when converting date time from character string.
  </code></pre>
  
  <p>Please help.</p>