关于datagrid的问题!谁遇到过这个问题?
我用下面的代码把datagrid里的数据导入excel里:
datagrid不分页时,可以正常运行,现在的问题是
datagrid分页时,会出现下面的错误:
[类型“DataGridLinkButton”的控件“DataGrid1__ctl24__ctl1”必须放在具有 runat=server 的窗体标记内。]
这个“DataGridLinkButton”的控件应该是分页的页码,但是这个问题是什么原因造成的?怎么解决呢?
Response.Clear()
Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel" '设置输出文件类型为excel文件。
Response.Charset = "utf-8"
Me.EnableViewState = False
Response.AppendHeader("Content-Disposition", "attachment;filename=" & savefilename)
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8") '设置输出流为简体中文
Dim myCItrad As System.Globalization.CultureInfo = New System.Globalization.CultureInfo("ZH-CN", True)
Dim oStringWriter As System.IO.StringWriter = New System.IO.StringWriter(myCItrad)
Dim oHtmlTextWriter As System.Web.UI.HtmlTextWriter = New System.Web.UI.HtmlTextWriter(oStringWriter)
Me.DataGrid1.RenderControl(oHtmlTextWriter)
Response.Write(oStringWriter)
Response.Flush()
Response.Close()
Response.End()