原文:http://www.codeproject.com/Tips/806934/How-to-Return-the-Contents-of-a-CSV-file-as-a-Gene
保存之后用txt文本编辑器打开,可以看到下面的内容:
id,name,age,addtime
1,jon,28,2014/8/13
//=======================================================================
其实就是像读取txt文本一样,按行读取即可,注意空判断:
public List<Platypus> GetPlatypus(string pondNum)
{
List<Platypus> platypus = new List<Platypus>();
const String PlatypusBase = @"C:\Duckbills\PlatypusPalace{0}.csv";
String fileToLoad = String.Format(PlatypusBase, pondNum);
using (StreamReader r = new StreamReader(fileToLoad))
{
string line;
while ((line = r.ReadLine()) != null)
{
string[] parts = line.Split(',');
// Skip the column names row
if (parts[0] == "id") continue;
Platypus dbp = new Platypus();
dbp.Id = Convert.ToInt32(parts[0]);
dbp.duckbillName = parts[1];
dbp.billLength = Convert.ToInt32(parts[2]);
dbp.poisonToeLength = Convert.ToInt32(parts[3]);
dbp.description = parts[4];
platypus.Add(dbp);
}
}
return platypus;
}
List<Platypus> platypi = new List<Platypus>();
platypi = GetPlatypus("1879");