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; } }
转载请注明原文地址: https://ibbs.8miu.com/read-29114.html