Datagrid导出EXCEL

 

            Response.ContentType = "application/vnd.ms-excel";
            Response.Charset = "";
            this.EnableViewState = false;
            System.IO.StringWriter sw = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
            int nCur = dgShow.CurrentPageIndex;
            int nSize = dgShow.PageSize;
            
            dgShow.AllowPaging = false;
            BindData();
                
            dgShow.Columns[7].Visible =false;
            dgShow.RenderControl(hw);
            dgShow.Columns[7].Visible =true;
            
            //以下恢复分页
            dgShow.AllowPaging = true;
            dgShow.CurrentPageIndex = nCur;
            dgShow.PageSize = nSize;
            BindData();
            Response.Write(sw.ToString());
            Response.End();