title: Convert String to Datetime in dd.MM.yyyy format without hours C#
body: <p>I've searched whole site and Google and couldn't find what I really need. I am trying to select records from SQL server DB between 2 dates (DB column is in date format not datetime). I take the dates from two TextBox (21.8.2014 format) and query is <code>BirthDay &gt;= dateTxt1 AND BirthDay&lt;=dateTxt2</code> 
  dateTxt1 and dateTxt2 should be a DateTime not a string. 
  Please do not offer me to use ToShortDateTimeString("dd.MM.yyyy"). I want something like this:</p>
  
  <pre><code>DateTime ddateTxt1 =Convert.toDateTime(TextBox1.Text, "dd.MM.yyyy");
  </code></pre>
  
  <p>Is that possible? output should be like 21.8.2014, not like 21.8.2014 00:00:00 
  How can I get the value from TextBox and convert it to DateTime and make a query.</p>
  
  <p>I've tried belov code but didn't work:</p>
  
  <pre><code>CultureInfo provider = CultureInfo.InvariantCulture;        
  
  DateTime theDateTime = DateTime.ParseExact(TextBox1.Text, "d.MMMM.yyyy", provider);
  </code></pre>
  
  <p>Thank you</p>