DataGrid导出EXCEL问题?
页面A:一个DataGrid,一个导出Excel按纽。
点击按纽,打开另外一个页面B,在页面B中导出Excel
问题:怎么把DataGrid的数据,传到页面B中?
(页面B怎么获得页面A中DataGrid的数据)
导出Excel的代码:
Response.Clear()
Response.Buffer = True
Response.Charset = "utf-8"
Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls")
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8")
Response.ContentType = "application/ms-excel"
Me.EnableViewState = False
Dim myCItrad As New System.Globalization.CultureInfo("ZH-CN", True)
Dim tw As System.IO.StringWriter
tw = New System.IO.StringWriter
Dim hw As System.Web.UI.HtmlTextWriter
hw = New HtmlTextWriter(tw)
mydatagrid.RenderControl(hw)
Response.Write(tw.ToString())
Response.End()