GridView导出电子表格 asp.net

[尐孑]

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();
}