怎么将分页的GridView数据导入到Excel中
GridView是分页的
GridView是分页的
解决方案 »
- 大家说说如何实现刷新提交无提示
- 读取pop邮件的问题
- 程序执行思路问题,大家提个意见,都有分。
- 在Orcale过程中,生成了动态的insert 语句:Sql_insert:='insert into '|| srctable || '('||fielda,filedb||')'|| ' values( '|| a,b ||')
- 用HttpWebRequest请求网页产生的HTML代码怎么和直接访问这个网页产生的代码不一样?帮帮.!!
- 请教一下DBSession是什么东西?
- 求这种超复杂的控件
- 这个错误怎么改正啊?
- 为什么使用文本框显示数据库的数据时仅显示一部分?
- 未将对象引用设置到对象的实例
- 如何组建一个局域网,共同上网
- 简单的触发器!!在线!!!
//只导当前这一页
protected void Button2_Click(object sender, EventArgs e)
{ Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
Response.ContentEncoding = Encoding.UTF7; StringWriter oStringWriter = new StringWriter();
HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter); GridView2.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.Flush();
Response.End();
} //必须加这个方法,要不然会引发:类型“GridView”的控件“GridView1”必须放在具有 runat=server 的窗体标记内... 异常。
public override void VerifyRenderingInServerForm(Control control)
{
//base.VerifyRenderingInServerForm(control);
}
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="BillOutOrder.aspx.cs" Inherits="Company_BillOutOrder" EnableEventValidation="false"%>
读取所有数据,字符串拼接table,然后利用我刚才说的方法导。方法二:
利用Sql语句导 :
exec Emp..xp_cmdshell 'bcp "select * from Emp.dbo.EB" queryout f://a.xls -c -S wjj -U wjj -P 000150'导到服务上,然后下载。
Response.Clear();
Page.Response.Buffer = true;
Response.Charset = "gb2312";
string strFileName = "FileName.xls";
Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode (strFileName, System.Text.Encoding.UTF8));
Response.ContentEncoding = System.Text.Encoding.UTF8; System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
gvIndex.AllowPaging = false;
gvIndex.ShowFooter = true;
NewBind();
gvIndex.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
gvIndex.AllowPaging = true;
NewBind();
Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
Response.ContentEncoding = Encoding.UTF7;
Response.Write("<table>.....</table>");
Response.Flush();
Response.End();
Page.Response.Buffer = true;
Response.Charset = "gb2312";
string strFileName = "FileName.xls";
Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode (strFileName, System.Text.Encoding.UTF8));
Response.ContentEncoding = System.Text.Encoding.UTF8; System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
gvIndex.AllowPaging = false;
gvIndex.ShowFooter = true;
NewBind();
gvIndex.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
gvIndex.AllowPaging = true;
NewBind();
好像还要指定路径吧
方法是 将数据放到一个DateTable中
在将DateTable数据导出到Excel