gvSMS.AllowPaging = false; //清除分页 gvSMS.AllowSorting = false; //清除排序 bindGrid(); //你绑定gridview1数据源的那个函数。 Response.Clear(); Response.Buffer = true; Response.Charset = "GB2312"; Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMddHHmmss", System.Globalization.DateTimeFormatInfo.InvariantInfo) + ".xls"); //.xls的文件名可修改 Response.ContentEncoding = System.Text.Encoding.UTF7; Response.ContentType = "application/ms-excel"; //设置输出文件类型为excel文件。 System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); gvSMS.RenderControl(oHtmlTextWriter); Response.Output.Write(oStringWriter.ToString()); Response.Write("<table><tr><td colspan=3 align=center><strong>共:</strong><font color='red'>" + lblCount.Text + "</font><strong>条记录</strong></td></tr></table>"); Response.Flush(); Response.End(); gvSMS.AllowSorting = true; //恢复分页 GridView1.AllowPaging = true; //恢复排序 bindGrid(); //再次绑定
GridView导出全部信息
最新推荐文章于 2024-05-16 21:23:15 发布