用Text驱动访问.cvs文件

using System;
using System.Web;
using System.Data;
using System.Data.OleDb;
using System.Data.Odbc;
using DataObjManage;
using System.IO;

namespace BookOrder
{
 public class getCSVData
 {
  public getCSVData()
  {
  }
  /// <summary>
  /// getData2Object
  /// </summary>  
  /// <param name="sql">select columns</param>
  /// <param name="path">from file path @</param>
  /// <param name="filename">from CSV file @</param>
  public getCSVData(string sql,string path,string filename)
  {

  }
  public void dd(){}
  public DataTable doGet(string sql,string path,string filename)
  {   
   if (sql == "" || sql == null)
   {
    sql = @" * ";
   }
   if (path == "" || path == null)
   {
    path = @System.Web.HttpContext.Current.Server.MapPath("");
   }
   string strConn = @"Driver={Microsoft Text Driver (*.txt; *.csv)};" +
    "Dbq="+path+";Extensions=csv,txt";
   try
   {
    OdbcConnection objCSV = new OdbcConnection(@strConn);
    objCSV.Open();

    FileInfo fl = new FileInfo(@filename);
    sql  = @"select "+sql;
    sql += @" from [" +fl.Name +"]";

    DataTable dt = new DataTable();
    OdbcDataAdapter da = new OdbcDataAdapter(@sql, @objCSV);
    da.Fill(dt);

    da.Dispose();
    objCSV.Close();
    return dt;
   }
   catch (Exception ex) {return null;}
  }
 }
}