Net读取(上传的)Excel内容显示到GridView示例源代码

网上转载……

//上传文件
            string filename = FileUpload1.FileName;
            string path = Server.MapPath("c:\\123\\" + filename);
            FileUpload1.SaveAs(path);
        

            string strConn = GetExcelConnString(path);
            OleDbConnection conn = new OleDbConnection(strConn);
            try
            {
                conn.Open();
            }
            catch (Exception ex)
            {
                //ShowClientJS("ShowInfo(\"错误：" + ex.Message + "\",1,5000);", this);
                return;
            }

//判断工作表个数
            DataTable dtTblNames = conn.GetSchema("Tables");
            if (dtTblNames.Rows.Count > 1)
            {
                conn.Close();
                //ShowClientJS("ShowInfo('导入失败：只允许1个工作表，当前有：" + dtTblNames.Rows.Count.ToString() + "',1,5000);", this);
                return;
            }
//只处理第一个工作表
            string tblName = dtTblNames.Rows[0]["Table_Name"].ToString();
            hidTableName.Value = tblName;
            OleDbCommand cmd = new OleDbCommand();
            cmd.Connection = conn;
            cmd.CommandText = "select * from [" + tblName + "]";
            OleDbDataAdapter da = new OleDbDataAdapter(cmd);
            DataTable dt = new DataTable();
            try
            {
                da.Fill(dt);
            }
            catch (Exception ex)
            {
                //ShowClientJS("ShowInfo(\"预览时发生错误：" + ex.Message + "\",1,5000);", this);
            }
            finally
            {
                conn.Close();
            }
//显示数据
            GridView1.DataSource = dt;
            GridView1.DataBind();

Copyright ＠ 2007-2012 敏韬网(敏而好学，文韬武略--MinTao.Net)（学习笔记） Inc All Rights Reserved.
闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)

鄂公网安备 42011102001154号

站长：MinTao ICP备案号：鄂ICP备11006601号-18