注册 | 登录 忘记密码? 51cto首页 | 博客 | 论坛 | 招聘
热点文章 获取当前页面路径,实现权..
 帮助

如何将GRIDVIEW导出到EXCEL


2006-06-24 09:50:37
 标签:Excel   [推送到技术圈]

Sub ExportExcel(ByVal send As Object, ByVal e As EventArgs)
'导出EXCEL
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Me.EnableViewState = False
Dim sw As System.IO.StringWriter = New System.IO.StringWriter()
Dim hw As System.Web.UI.HtmlTextWriter = New ystem.Web.UI.HtmlTextWriter(sw)
Dim nCur As Integer = GridView1.PageIndex
Dim nSize As Integer = GridView1.PageSize
GridView1.AllowPaging = False
GridView1.DataBind()

GridView1.RenderControl(hw) '这一句出错!!!

GridView1.AllowPaging = True
GridView1.PageIndex = nCur
GridView1.PageSize = nSize
GridView1.DataBind()
Response.Write(sw.ToString())
Response.End()
End Sub

“/Asp.netBase”应用程序中的服务器错误。
--------------------------------------------------------------------------------

类型“GridView”的控件“ctl00_ContentPlaceHolder1_GridView1”必须放在具有 runat=server 的窗体标记内。

解决方法: 加入

Public Overrides Sub VerifyRenderingInServerForm(ByVal control As System.Web.UI.Control)

End Sub

本文属本人原创^_^






    文章评论
 
2007-11-21 06:12:04
非常感谢,解决了在asp.net ajax updatepanel内GridView数据导出到Excel时的问题。

2008-06-11 13:31:26
文章很不错,也欢迎博主访问我的技术blog:
http://xiaowang.blog.51cto.com

 

发表评论

昵   称:
验证码:  点击图片可刷新验证码  博客过2级,无需填写验证码
内   容: