title: How to change date format for the date column in datatable?
body: <p>I am filling the datable from database.
  It contains two field: <code>DATE</code>, <code>TIME</code></p>
  
  <p>Both the fields are <code>datetime</code> column</p>
  
  <p>I want to iterate through the datatable and change the date format for the <code>DATE</code> column i.e <code>dd/MM/yyyy</code></p>
  
  <pre><code>int i = 0;
  string d="";
  foreach (DataRow dr in dataTable.Rows)
  {
      d = dr["DATE"].ToString();
      DateTime date = Convert.ToDateTime(d);
      d = date.ToString("dd/MM/yyyy");
      dataTable.Rows[i]["DATE"] = d;
      i++;
  }
  </code></pre>
  
  <p>I get the following error</p>
  
  <blockquote>
    <p><em>String was not recognized as a valid DateTime.</em></p>
  </blockquote>
  
  <p>Couldn't store <code>&lt;15/02/2015&gt;</code> in DATE Column.  Expected type is DateTime. How can I achieve it?</p>