title: csv reading using OLEDB command
body: <p>Am trying to read a csv file using oledb command. Following is am using.
  This code execute smoothly. But i need to remove first row from csv file and set second row as column header of the datatable. Is it possible?</p>
  
  <pre><code>static DataTable ImportCsvFileToDataTable(string filename, string fullPath)
  {
      FileInfo file = new FileInfo(fullPath);
  
      using (OleDbConnection con =
                 new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"" +
                 file.DirectoryName + "\";Extended Properties='text;HDR=Yes;FMT=Delimited(,)';"))
      {
          using (OleDbCommand cmd = new OleDbCommand(string.Format
                                    ("SELECT * FROM [{0}]", file.Name), con))
          {
              con.Open();
  
              // Using a DataTable to process the data
              using (OleDbDataAdapter adp = new OleDbDataAdapter(cmd))
              {
                  DataTable tbl = new DataTable(filename);
                  adp.Fill(tbl);
                  return tbl;
              }
          }
      }
  }
  </code></pre>