csv文件, 俗稱"逗號分隔的文件", 讀取csv文件的方法可以使用iostream按照即定格式讀取...

我以為就這一種方法呢, 呵呵. 直到有一天.在www.connectionstrings.com上看到文本的連接

字符串:

 text

•  odbc
  
  
  •  standard:
    "driver={microsoft text driver (*.txt; *.csv)};dbq=c:/txtfilesfolder/;extensions=asc,csv,tab,txt;"
    
•  ole db
  
  
  •  standard:
    "provider=microsoft.jet.oledb.4.0;data source=c:/txtfilesfolder/;extended properties=""text;hdr=yes;fmt=delimited"""

    "hdr=yes;" indicates that the first row contains columnnames, not data

  
  
  
  •  standard:
    "driver={microsoft text driver (*.txt; *.csv)};dbq=c:/txtfilesfolder/;extensions=asc,csv,tab,txt;"
    
•  ole db
  
  
  •  standard:
    "provider=microsoft.jet.oledb.4.0;data source=c:/txtfilesfolder/;extended properties=""text;hdr=yes;fmt=delimited"""

    "hdr=yes;" indicates that the first row contains columnnames, not data

  
  
  
  •  standard:
    "provider=microsoft.jet.oledb.4.0;data source=c:/txtfilesfolder/;extended properties=""text;hdr=yes;fmt=delimited"""

    "hdr=yes;" indicates that the first row contains columnnames, not data

這里不是有csv么?呵呵,可以試一下啊, 試驗結果很不錯.可以使用odbc來連接.把csv當作數據庫,

感覺不錯.(oledb的沒成功, 將properties=text改為properties=csv不好使,是不支持,還是我寫錯?)

因此這里提供一種方法.( 肯定不是我發明的哦), 使用odbc連接方式,通過dataadapter直接將

數據快速導入dataset, 很方便.方法如下：

 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;
   }  
  }