protected void Page_Load(object sender, EventArgs e)
{
string paths = Server.MapPath("");
DataSet ds3= getcsv(paths, paths+"2010年淘趣后台导入价格表样式20100828.csv");
GridView1.DataSource = ds3;
GridView1.DataBind();
}
private DataSet getcsv(string filepath, string filename)
{
string strconn = @"driver={microsoft text driver (*.txt; *.csv)};dbq=";
strconn += filepath;
strconn += ";extensions=asc,csv,tab,txt;";
System.Data.Odbc.OdbcConnection con = new OdbcConnection(strconn);
DataSet data = new DataSet();
string sql = "select 材质,品牌 from " + filename;
OdbcDataAdapter adp = new OdbcDataAdapter(sql, con);
// con.open();
adp.Fill(data);
return data;
}
protected void Page_Load(object sender,