Exporting data from a paged datagrid to excel
-
Hi I am using the following piece of code to export my data to an excel file Response.ContentType = "application/vnd.ms-excel" ' Remove the charset from the Content-Type header. Response.Charset = "" ' Turn off the view state. Me.EnableViewState = False Dim tw As New System.IO.StringWriter() Dim hw As New System.Web.UI.HtmlTextWriter(tw) ' Get the HTML for the control. DataGrid1.RenderControl(hw) ' Write the HTML back to the browser. Response.Write(tw.ToString()) ' End the response. Response.End() This works fine if there is only one page of data but when it has multiple pages it gives me the following error Control 'DataGrid1__ctl24__ctl1' of type 'DataGridLinkButton' must be placed inside a form tag with runat=server. How do i resolve this issue
-
Hi I am using the following piece of code to export my data to an excel file Response.ContentType = "application/vnd.ms-excel" ' Remove the charset from the Content-Type header. Response.Charset = "" ' Turn off the view state. Me.EnableViewState = False Dim tw As New System.IO.StringWriter() Dim hw As New System.Web.UI.HtmlTextWriter(tw) ' Get the HTML for the control. DataGrid1.RenderControl(hw) ' Write the HTML back to the browser. Response.Write(tw.ToString()) ' End the response. Response.End() This works fine if there is only one page of data but when it has multiple pages it gives me the following error Control 'DataGrid1__ctl24__ctl1' of type 'DataGridLinkButton' must be placed inside a form tag with runat=server. How do i resolve this issue
Hi there,
smita_roy wrote:
Control 'DataGrid1__ctl24__ctl1' of type 'DataGridLinkButton'
I did not see the GridLinkControl, or maybe u rendered it in HtmlTextWriter, right?
smita_roy wrote:
Control 'DataGrid1__ctl24__ctl1' of type 'DataGridLinkButton' must be placed inside a form tag with runat=server.
it sounds that the GridLinkControl is outside the
tag Not sure... ;P << >>
-
Hi I am using the following piece of code to export my data to an excel file Response.ContentType = "application/vnd.ms-excel" ' Remove the charset from the Content-Type header. Response.Charset = "" ' Turn off the view state. Me.EnableViewState = False Dim tw As New System.IO.StringWriter() Dim hw As New System.Web.UI.HtmlTextWriter(tw) ' Get the HTML for the control. DataGrid1.RenderControl(hw) ' Write the HTML back to the browser. Response.Write(tw.ToString()) ' End the response. Response.End() This works fine if there is only one page of data but when it has multiple pages it gives me the following error Control 'DataGrid1__ctl24__ctl1' of type 'DataGridLinkButton' must be placed inside a form tag with runat=server. How do i resolve this issue
Hi there, When you export the datagrid control to excel, you basically render the control and send the output html markup to the the client side. When the datagrid control is rendered, it also renders its child controls, and there are a couple of controls like LinkButton .... that require to be placed in a server form when they render. So in this case, you need to clear those controls before exporting, you can have a look at an example from here[^]. Another way is to use a second datagrid that simply contains the controls for display like label ... only to do the exporting.