title: How to format datetime to only specific DATE format in datatable
body: <p>In my datagridview1, the DATE column show format "MM/dd/yyyy hh:mm:ss"</p>
  
  <p>Then I use this code.</p>
  
  <p>I use a function to fill a datagridview like this</p>
  
  <pre><code>public void load_table()
  {
      DataTable ltdgv = getLoad_table(); 
      //the getLoad_table() function return a datatable type and store it to ltdgv
  
     foreach (DataRow dr in ltdgv.Rows)
     {
         dr["DATE"] = DateTime.Parse((dr["DATE"].ToString())).ToShortDateString();
     }
  
     dataGridView1.DataSource = ltdgv;           
  }
  </code></pre>
  
  <p>but the DATE column still showing format MM/dd/yyyy [ex: 11/27/2016]</p>
  
  <p>but I want to change it to dd/MM/yyyy or 27/11/2016</p>
  
  <p>I tried to change it into =</p>
  
  <pre><code>dr["DATE"] = DateTime.Parse((dr["DATE"].ToString("dd/MM/yyyy"))).ToShortDateString();
  // I fill a parameter to the .ToString()
  </code></pre>
  
  <p>But I now get a "syntax error".</p>
  
  <p>So, how to fix this?</p>