vb.net2005中将gridview中的数据导出为EXECL - 风云 - 51CTO技术博客-领先的IT技术博客

vb.net2005中将gridview中的数据导出为EXECL

author:boyi55

在按钮上定义导出EXECL事件。

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Response.Clear()
 Response.Buffer = True
Response.Charset = "GB2312"
Response.AppendHeader("Content-Disposition", "attachment;filename=month_loginout.xls")
Response.ContentEncoding = System.Text.Encoding.UTF7
 Response.ContentType = "application/ms-excel"
Dim oStringWriter As System.IO.StringWriter = New System.IO.StringWriter
Dim oHtmlTextWriter As System.Web.UI.HtmlTextWriter = New System.Web.UI.HtmlTextWriter(oStringWriter)
Me.GridView1.RenderControl(oHtmlTextWriter)
Response.Output.Write(oStringWriter.ToString)
Response.Flush()
Response.End()
End Sub
' 重载 VerifyRenderingInServerForm

 Public Overloads Overrides Sub VerifyRenderingInServerForm(ByVal control As Control)

End Sub

-------------------------------

出现错误：

只能在执行 Render() 的过程中调用 RegisterForEventValidation的错误提示。

解决方案:
直接在导出Execl的页面修改
<%@ Page Language="VB" EnableEventValidation = "false" AutoEventWireup="true"

CodeFile="ExportGridView.aspx.cs" Inherits="ExportGridView" %>