title: Convert TextBox value to DateTime SQL Server
body: <p>I made a date picker from  the calendar control in ASP.net using C#. The date format in the TextBox is <code>08/01/2012</code>.</p>
  
  <p>When I try to do an insert I get this error:</p>
  
  <blockquote>
    <p>Message: Input string was not in a correct format.</p>
  </blockquote>
  
  <p>here is my code: </p>
  
  <pre><code>cmd.Parameters.Add("@date", SqlDbType.DateTime).Value = 
           Convert.ToDateTime(txtDateins.Text);
  </code></pre>
  
  <p>How do I get that fixed ?</p>