GridView导出电子表格

protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=caigoudan.xls");
        //Response.Charset = "GB2312";
        Response.ContentEncoding = System.Text.Encoding.UTF7;
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        GridViewMain.AllowPaging = false;
        this.Bind();
        GridViewMain.RenderControl(htmlWrite);
        ClientScript.RegisterClientScriptBlock(typeof(string),"timeover",stringWrite.ToString());
        Response.End();
        GridViewMain.AllowPaging = true;
        this.Bind();
    }

    private void Bind()
    {
        string strQuery = "SELECT * FROM JXNF_VIEW_ZUIZHONGCAIGOU WHERE HEADID = " + Request["id"] + " ORDER BY PROVIDERNAME ASC";
        GridViewMain.DataSource = GridViewMain.DataSource = PlatForm.NamedObjects.NonTransactionDatabaseAgent.ExecuteDataTable(strQuery);
        GridViewMain.DataBind();
    }