gridview无法导出
导出按钮不好使,单击时不出现导出的对话框。
是有几台机器不好使,而且是今天开始不好使的,能是什么原因。
大侠帮分析分析。
下面是导出的代码。
private void Export_Execl(string FileName)
{
GridView1.AllowPaging = false; //清除分页
GridView1.AllowSorting = false; //清除排序
GvBind(); //你绑定gridview1数据源的那个函数。
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString() + ".xls"); //.xls的文件名可修改
Response.ContentEncoding = System.Text.Encoding.UTF8;
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);
GridView1.RenderControl(oHtmlTextWriter);
Response.Output.Write(oStringWriter.ToString());
Response.Flush();
Response.End();
GridView1.AllowSorting = true; //恢复分页
GridView1.AllowPaging = true; //恢复排序
GvBind(); //再次绑定
}