title: how to set custom date format for specific column in datagridview? - c#
body: <p>I am having many fields in a table.</p>
  
  <p>Each field contains different data types i.e text, number, date/time.</p>
  
  <p>I am displaying the table in datagridview.</p>
  
  <p>Default date format is M/dd/yyyy.</p>
  
  <p>But i want the date to display in a custom format i.e dd/M/yyyy in a datagridview.</p>
  
  <p>I tried changing the format in default cell style as dd/M/yyyy. Now the date column works fine but the number columns are displaying as dd/M/yyyy.</p>
  
  <pre><code>string connetionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=database1.mdb;";
  // select * from ~tablename~; 
  string sql = "select * from table1";
  OleDbConnection connection = new OleDbConnection(connetionString);
  OleDbDataAdapter dataadapter = new OleDbDataAdapter(sql, connection);
  DataSet ds = new DataSet();
  connection.Open();
  dataadapter.Fill(ds, vehicleno);
  dataGridView1.DataSource = ds.Tables[0];
  connection.Close();
  </code></pre>
  
  <p>How do I set custom date format for specific column in datagridview?</p>