gridview导出excel并上传

最新推荐文章于 2013-06-20 10:34:55 发布

给力地板油

最新推荐文章于 2013-06-20 10:34:55 发布

阅读量420

点赞数

分类专栏： c#(asp.net) 文章标签： excel dataset string file null

本文链接：https://blog.csdn.net/wslyy99/article/details/4803625

版权

c#(asp.net) 专栏收录该内容

56 篇文章 0 订阅

订阅专栏

using System.IO;

            DataSet dsnew = new DataSet();
            string _sqlStr = "select * from test";
            using (DBManage _db = new DBManage())
            {
                dsnew = _db.GetDataSet(_sqlStr);
            }
            if (dsnew.Tables[0].Rows.Count > 0)
            {
                if (!GridView2.Visible) { GridView2.Visible = true; }
                GridView2.DataSource = dsnew.Tables[0].DefaultView;
                GridView2.DataBind();
                GridView2.AllowPaging = false;
                StringWriter stringWriter = new StringWriter();
                HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);
                GridView2.RenderControl(htmlWriter);
                GridView2.Visible = false;

                string filename = "test.xls";
                string filestr = Server.MapPath("test") + "//" + filename;
                int pos = filestr.LastIndexOf("//");
                string file = filestr.Substring(0, pos);
                if (!Directory.Exists(file))
                {
                    Directory.CreateDirectory(file);
                }
                StreamWriter sw = new StreamWriter(filestr);
                sw.Write(stringWriter.ToString());
                sw.Close();

                GridView2.DataSource = null;
                GridView2.DataBind();
            }