导出GridView到Excel中的关键之处(downmoon)

导出GridView到Excel中的关键之处
用法: ToExcel(GVStaff, TextBox1.Text);

public static void ToExcel(System.Web.UI.Control ctl,string FileName)
        
{
            HttpContext.Current.Response.Charset 
="UTF-8";
            HttpContext.Current.Response.ContentEncoding 
=System.Text.Encoding.Default;
            HttpContext.Current.Response.ContentType 
="application/ms-excel";
            HttpContext.Current.Response.AppendHeader(
"Content-Disposition","attachment;filename="+""+FileName+".xls");
            ctl.Page.EnableViewState 
=false;
            System.IO.StringWriter  tw 
= new System.IO.StringWriter();
            HtmlTextWriter hw 
= new HtmlTextWriter(tw);
            ctl.RenderControl(hw);
            HttpContext.Current.Response.Write(tw.ToString());
            HttpContext.Current.Response.End();
        }
        


    
必须有下面这句!否则不会通过!

public override void VerifyRenderingInServerForm(Control control)
    {
        // Confirms that an HtmlForm control is rendered for
    }

posted @ 2007-12-29 08:56  邀月  阅读(511)  评论(0编辑  收藏  举报