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