title: Change the datetime display format on datagridview date column
body: <p>I want to change the default format(<code>MM/dd/yyyy</code>) of the datetime in the database table to (<code>dd/MM/yyyy</code>) when select and write the date with (<code>dd/MM/yyyy</code>) on the datagridview's date column. </p>
  
  <p>Below is my code to convert string input date for instance: <code>24/4/201</code>3 to datetime and then convert to 
  <code>4/24/2013</code> using query and select records from database.</p>
  
  <pre><code>   string date = this.ToolStripTextBox2.Text;
     DateTime dtDate = DateTime.ParseExact(date, "d/M/yyyy", null);
  </code></pre>
  
  <p>Query: FillByDate</p>
  
  <pre><code>   SELECT Record_ID, Grade, Type, 
     CONVERT(VARCHAR(10), CAST(Date AS DATETIME), 103) AS Date 
     FROM RecordsTable
     WHERE Date &gt;= CONVERT(datetime, @fromDate, 105) 
     AND Date &lt;= CONVERT(datetime, @toDate, 105)
     ORDER BY Date ASC
  </code></pre>
  
  <p>But it give this error;</p>
  
  <blockquote>
    <p>"String was not recognized as a valid DateTime.Couldn't store
    &lt;24/04/2013> in Date Column.  Expected type is DateTime."</p>
  </blockquote>
  
  <p>I know that the CONVERT part was wrong as if I remove the convert part out,
  the date column can be written but in <code>4/24/2013</code> format.
  I have no idea how to correct it. Anyone can help?
  Thanks</p>