将GridView中的结果导出成Excel文件格式

 protected void Button1_Click(object sender, EventArgs e)
    {
        Export("application/ms-excel", "Nor.xls");
    }

    private void Export(string FileType,string FileName)
    {
        Response.Charset = "GB2312";
        Response.ContentEncoding = System.Text.Encoding.UTF8;
        Response .AppendHeader ("Content-Disposition","attachment;filename="+HttpUtility.UrlEncode (FileName ,Encoding.UTF8).ToString ());
        Response .ContentType = FileType ;

        this .EnableViewState = false ;
        StringWriter tw = new StringWriter();

        HtmlTextWriter hw = new HtmlTextWriter (tw);
        GridView1.RenderControl (hw);
        Response .Write (tw.ToString ());
        Response.End ();
    }

//没有这个复写方法,会报错。
    public override void VerifyRenderingInServerForm(Control control)
    {
 
    }

posted @ 2009-07-20 17:03  iZiYue  阅读(167)  评论(0编辑  收藏  举报
ChinaHDTV.ORG