Asp.net成功导出Excel

 

  protected void Button1_Click(object sender, EventArgs e)
    {       
        DataSet ds = new SqlDBhelper().queryallds("select * from tb_shop");
        DataTable dtData = ds.Tables[0];
        dtData.Columns.Remove("s_img");
        dtData.Columns.Remove("s_bigimg");
        dtData.Columns.Remove("type_id");
        dtData.Columns.Remove("type_name");

        //以下注释为加密字段，可写可不写

        //foreach (DataRow drData in dtData.Rows)
        //{
        //    drData["Password"] = DESEncrypt.DecryptPsw(drData["Password"].ToString());
        //}

        dtData.AcceptChanges();

        System.Web.UI.WebControls.GridView dgExport = null;
        System.Web.HttpContext curContext = System.Web.HttpContext.Current;
        System.IO.StringWriter strWriter = null;
        System.Web.UI.HtmlTextWriter htmlWriter = null;
        System.Web.HttpContext.Current.Response.Clear();
        System.Web.HttpContext.Current.Response.HeaderEncoding = System.Text.Encoding.GetEncoding("utf-8");
        curContext.Response.ContentType = "application/vnd.ms-excel";
        string fileName = "SurveySubject_" + DateTime.Now.ToFileTimeUtc() + ".xls";
        curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName);
        curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;
        System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
        curContext.Response.Charset = "";

        strWriter = new System.IO.StringWriter();
        htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
        dgExport = new System.Web.UI.WebControls.GridView();
        dgExport.DataSource = dtData.DefaultView;
        dgExport.AllowPaging = false;
        dgExport.DataBind();
        dgExport.RenderControl(htmlWriter);
        curContext.Response.Write(strWriter.ToString());
        curContext.Response.End();
   
    }