gridview导出excel总结

最新推荐文章于 2025-09-13 19:07:06 发布

weixin_30765319

最新推荐文章于 2025-09-13 19:07:06 发布

阅读量55

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/mengzi/archive/2009/03/24/1420310.html

        HttpContext curContext = System.Web.HttpContext.Current;
        System.IO.StringWriter strWriter = new StringWriter();
        System.Web.UI.HtmlTextWriter htmlWriter = new HtmlTextWriter(strWriter);
        curContext.Response.ContentType = "application/vnd.ms-excel";
        Response.Write("<meta http-equiv=Content-Type content=\"text/html; charset=GB2312\">");
        curContext.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
        curContext.Response.Charset = "GB2312";
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "server=.;database=zhddclxt;uid=sa;pwd=sa";
        conn.Open();

SqlCommand cmd = new SqlCommand("select * from allorder", conn);
cmd.ExecuteNonQuery();

        SqlDataReader DT = cmd.ExecuteReader();
        GridView GV = new GridView();//一个无分页的GridView
        GV.DataSource = DT;
        GV.AllowPaging = false;
        GV.DataBind();
        GV.RenderControl(htmlWriter);
        curContext.Response.Write(strWriter.ToString());
        curContext.Response.End();

转载于:https://www.cnblogs.com/mengzi/archive/2009/03/24/1420310.html