阅读背景:

把csv文件导入数据库

来源:互联网 
    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,



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: