title: Failed convert datetime,date,time using string?
body: <p>I get an error about datetime,date and time.. i got 3 different datatype , mostly error all of them.. how do i get it right?</p>
  
  <p>this datatype datetime: i dont know sometime i got it worked and some dont..</p>
  
  <pre><code>comu.Parameters.Add("Casedate", SqlDbType.DateTime);
  comu.Parameters["Casedate"].Value = Convert.ToDateTime(TextBox1.Text);
  </code></pre>
  
  <p>this are datatype date only: </p>
  
  <pre><code>comu.Parameters.Add("Startdate", SqlDbType.Date);
  comu.Parameters["Startdate"].Value = Convert.ToString(TextBox12.Text);
  
  comu.Parameters.Add("Enddate", SqlDbType.Date);
  comu.Parameters["Enddate"].Value = Convert.ToString(TextBox13.Text);
  </code></pre>
  
  <p>this are datatype time:</p>
  
  <pre><code>comu.Parameters.Add("Starttime", SqlDbType.Time);
  comu.Parameters["Starttime"].Value = Convert.ToString(TextBox14.Text);
  
  comu.Parameters.Add("Endtime", SqlDbType.Time);
  comu.Parameters["Endtime"].Value = Convert.ToString(TextBox15.Text);
  </code></pre>
  
  <p>now i have problem on datetime, but in the last page i got it worked by put in data 11/11/2014 data in it... but now it show error on datetime back</p>