.NET 导数据到excel

[perisenjut]

protected void ibtnExcel_Click(object sender, ImageClickEventArgs e)
{
string FileName = "标题 " + DateTime.Now + ".xls";
Response.Charset = "GB2312";
Response.ContentEncoding = Encoding.UTF8;//System.Text
//如果设置GB2312会出现乱码
Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.AddHeader("content-type", "application / ms - excel");//设置输出文件的类型
//或Response.ContentType = FileType;
//定义一个输出流
StringWriter tw = new StringWriter();//System.IO
HtmlTextWriter hw = new HtmlTextWriter(tw);
gridview1.RenderControl(hw);//gridview绑定
Response.Write(tw.ToString());
Response.End();
}

这样的方式导出的数据在excel里面只有gridview1分页的第一页，我想把所有的数据都显示出来，请问如何处理？

[子夜__]

这样的方式导出的数据在excel里面只有gridview1分页的第一页，我想把所有的数据都显示出来，请问如何处理

倒数据源。
google一下 DataSet导出EXCEL

[dalmeeme]

http://www.cnblogs.com/eugene512/archive/2009/06/29/dataset.html

[Ultimate]

gridview1.RenderControl(hw);//gridview绑定
你这个有的是gridview来做数据的绑定,那你可以重新声明一个 gridview ,让这个来绑定所有数据不要分页,再把你这里的gridview换掉就是了

[wosizy]

gridview1.RenderControl(hw);//gridview绑定

绑定数据源！

[色拉油]

好东西[Quote=引用 2 楼 dalmeeme 的回复:]

http://www.cnblogs.com/eugene512/archive/2009/06/29/dataset.html
[/Quote]

public static void ExportExcel(System.Web.UI.Control control,DataSet ds)
{
control.Page.Response.Clear();
control.Page.Response.Buffer = true;
control.Page.Response.ContentType = "application/vnd.ms-excel";
control.Page.Response.Charset = "";
control.Page.EnableViewState = false;

System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

System.Web.UI.WebControls.DataGrid dg = new System.Web.UI.WebControls.DataGrid();
dg.DataSource = ds;
dg.DataBind();
dg.RenderControl(oHtmlTextWriter);
control.Page.Response.Write(oStringWriter.ToString());
control.Page.Response.End();
}