Import from excel - Need to change different Date Value Formats

See more:

ASP.NET

C#5.0

When I import data from Excel using ACE.OLEDB, the date format from is different for each column

My date column in excel comes as "16.03.2015" or "3/16/2015 12:00:00 AM" I need a converter to get the date Value and format it to "MM/dd/yyyy" format.

I read the data using the following code

DataSet ds = new DataSet();
      string myConnStr = "";

      if (ds != null)
      {
       myConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +  FilePath     + "; " + "Extended Properties=\"Excel 12.0;HDR=YES\"";
      }
      else
      {
      myConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath +    ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";
      }

      OleDbConnection myConn = new OleDbConnection(myConnStr);
      try
      {
          OleDbCommand cmd = new OleDbCommand("select * from [Sheet1$]  ",myConn);
          OleDbDataAdapter adapter = new OleDbDataAdapter();
          adapter.SelectCommand = cmd;
          myConn.Open();
          adapter.Fill(ds);
       }
      catch
      { }
      finally
      {
          myConn.Close();
      }

I can't loop the data and convert.