读书人

repeater数据导出到Excel,该如何解决

发布时间: 2011-12-31 23:50:30 作者: rapoo

repeater数据导出到Excel
如题.网上的代码也有,但效果不是很理想或不能实现.请大家帮下忙~~最好有实现的方法代码(asp.net(C#))

[解决办法]

和 datagrid一样啊,基本原理也就是把数据库中的数据读出,组合成字符串输出就行了。。。
[解决办法]

C# code
 protected void Button1_Click(object sender, EventArgs e)    {        Response.Clear();        Response.AddHeader("content-disposition", "attachment;filename=file.xls");        Response.Charset = "GB2312";        Response.ContentEncoding = Encoding.UTF8;        Response.ContentType = "application/vnd.xls";        System.IO.StringWriter stringWrite = new System.IO.StringWriter();        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);        GridView1.AllowPaging = false;        EnableViewState = false;        GridView1.RenderControl(htmlWrite);        Response.Write(stringWrite.ToString());        Response.End();    }    public override void VerifyRenderingInServerForm(Control control)    {    } 

读书人网 >asp.net

热点推荐