title: C# String to DateTime Conversion issue Using ParseExact
body: <p>I am fetching date from textbox and passing it to dateTime by passing it though a function,</p>
  
  <p><strong>BUT it gives me two different results</strong></p>
  
  <pre class="lang-cs prettyprint-override"><code>DateTime Fromdate1 = devTools.ParseDate(datepicker1.Text);
  </code></pre>
  
  <p>TextBox --->OutPut</p>
  
  <p>02/09/2012 --> 2/9/2012 12:00:00 AM </p>
  
  <p>30/08/2012 --> 8/30/2012 12:00:00 AM</p>
  
  <pre class="lang-cs prettyprint-override"><code>public DateTime ParseDate(string s)
      {
          DateTime result;
          if (!DateTime.TryParse(s, out result))
          {
              string[] formats = { "dd'/'MM'/'yyyy" };
              result = DateTime.ParseExact(s, formats, new CultureInfo("en-US"), DateTimeStyles.None);
              //result = DateTime.ParseExact(s, "dd'/'MM'/'yyyy", System.Globalization.CultureInfo.InvariantCulture);
              //result = result.AddDays(1);
          }
          return result;
      }
  </code></pre>
  
  <p>What is the problem here,Is there a prper way to get constant output type,also it will create problems in DB since 08/09 will be checked against 09/08 and vice versa !</p>
  
  <p><strong>One more problem in SQL :</strong></p>
  
  <pre><code>Select convert(nchar(10),FromDate, 103) AS FromDate,convert(nchar(10),ToDate, 103) AS ToDate FROM Tbl_PropertyRoomSeasonPrices
  </code></pre>
  
  <p>OUTPUT :</p>
  
  <p>28/08/2012  |   09/01/2012</p>
  
  <p>dd/mm/yyyy  |   mm/dd/yyyy<br>
  (CORRECT)       (WRONG)</p>
  
  <p>but 103 for fromDate and 101 for toDate makes it both same,Why the variations ??</p>