ASP.NET实现增删改查等功能(Access版)系统之六-导出数据到EXCEL

/// <summary>

    ///导出Excel

    /// </summary>

    /// <param name="sender"></param>

    /// <param name="e"></param>

protected void ToExcel2()

    {

        // Response.Clear();

 

        Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");

        Response.Charset = "gb2312";

        Response.ContentType = "application/vnd.xls";

        Response.ContentEncoding = System.Text.Encoding.UTF8;

 

        System.IO.StringWriter stringWrite = new System.IO.StringWriter();

        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

 

        GridView1.AllowPaging = false;//导出前先取消分页，以便能将所有数据导出。

        GridView1.RowStyle.BackColor = Color.White;

        GridView1.AlternatingRowStyle.BackColor = Color.White;

        // GridView1.DataBind();//再重新绑定一次数据

        string sqlstr = getSQlStr();

        bind(sqlstr); //绑定

        int m = GridView1.Columns.Count;

        for (int i = 0; i < GridView1.Rows.Count; i++)

        {

            GridView1.Rows[i].Cells[m - 1].Visible = false;

            GridView1.Rows[i].Cells[m - 1].Enabled = false;

 

        }

 

        GridView1.RenderControl(htmlWrite);

        Response.Write(stringWrite.ToString());

        Response.End();

 

        // GridView1.AllowPaging = true;//导出后先取消分页，以便能将所有数据导出。

        GridView1.DataBind();//再重新绑定一次数据

    }