csv文件内容由多行构成，
每行是逗号分隔的字符串。
csv可以用excel来显示，但是不能使用excel来编辑保存。
用以下函数可以将csv读取到DataTable中。
public static DataTable ConverntToTable(string folderPath, string fileName)
{
OleDbConnection connection = null;
OleDbCommand command = null;
OleDbDataAdapter adapter = null;
try
{
connection = new OleDbConnection
{
ConnectionString = string.Format(@"
Provider=Microsoft.Jet.OLEDB.4.0;
Data Source={0};
Extended Properties='Text;FMT=Delimited;HDR=YES;CharacterSet=65001;'",
folderPath
)
};
connection.Open();
command = new OleDbCommand
{
Connection = connection,
CommandText = string.Format("SELECT * FROM {0}", fileName)
};
adapter = new OleDbDataAdapter
{
SelectCommand = command
};
DataSet csvData = new DataSet();
adapter.Fill(csvData, "Csv");
return csvData.Tables[0]; ;
}
finally
{
if (connection != null)
{
connection.Close();
connection.Dispose();
}
if (command != null)
{
command.Dispose();
}
if (adapter != null)
{
adapter.Dispose();
}
}
}
