public DataSet GetDataSetFromCSV( string filePath, string fileName) ... { string strConn = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq="; strConn += filePath; //filePath, For example: C: strConn += ";Extensions=asc,csv,tab,txt;" ; OdbcConnection objConn = new OdbcConnection(strConn); DataSet dsCSV = new DataSet(); try ...{ string strSql = "select * from " + fileName; //fileName, For example: 1.csv OdbcDataAdapter odbcCSVDataAdapter = new OdbcDataAdapter(strSql, objConn); odbcCSVDataAdapter.Fill(dsCSV); return dsCSV; } catch(Exception ex) ...{ throw ex; } }