problem when exporting gridview content into excel

Question

I have a Master page and a child page in child page i have  a gridview showing the record set i want to export and print this records so i am using that code on button click event ... Response.Clear() Response.Buffer = True Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.doc") Response.Charset = "" Response.ContentType = "application/vnd.ms-word " Dim sw As New StringWriter() Dim hw As New HtmlTextWriter(sw) grdUserReports.AllowPaging = False grdUserReports.DataBind() grdUserReports.RenderControl(hw) Response.Output.Write(sw.ToString()) Response.Flush() Response.End()   The highlited row gives error that "Control 'ctl00_ContentPlaceHolder1_grdUserReports' of type 'GridView' must be placed inside a form tag with runat=server."

Upendra Pratap Shahi · Answer

try to use JSON dear. If some help accept the answer for better discussion.

Saroj Kumar Sahu · Answer

If you want update panel then u need to add one trigger for button click inside the update panel.         ControlID = "btnPrintAll" />     If no luck,please attach your code sample as zip format.

Saroj Kumar Sahu · Answer

Hi,
As per your code I figured it out that you are not binding gridview before export. Make sure you load all the data and bind it to gridview before export.   Please go through the following tutorial to export excel .   http://www.aspsnippets.com/Articles/Export-GridView-to-Excel-in-ASPNet-with-Formatting-using-C-and-VBNet.aspx  http://www.webblogsforyou.com/export-gridview-data-to-word-excel-text-pdf-file-asp-net-c-vb/

Danish Habib · Answer

I have dropped the gridview from update panle and now it works fine but update panel is my requirement how to go ahead with export functionality with update panel also in my page.

Upendra Pratap Shahi · Answer

put your gridview outside the update panel.

Danish Habib · Answer

I have already this code in code behind  Public Overloads Overrides Sub VerifyRenderingInServerForm( ByVal control As Control) Exit Sub End Sub   but my gridview is in update panel does update panel is creating issue??

Upendra Pratap Shahi · Answer

add below code in code behind file     Public Overloads Overrides Sub VerifyRenderingInServerForm( ByVal control As Control) Exit Sub End Sub

Danish Habib · Answer

I am using that code my html markup is
and code behind is
Protected Sub ExportToExcel(sender As Object, e As EventArgs)
Response.Clear()
Response.Buffer = True
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls")
Response.Charset = ""
Response.ContentType = "application/vnd.ms-excel"
Using sw As New StringWriter()
Dim hw As New HtmlTextWriter(sw)
'To Export all pages
grdUserReports.AllowPaging = False
Me.SearchReportUser()
grdUserReports.HeaderRow.BackColor = Color.White
For Each cell As TableCell In grdUserReports.HeaderRow.Cells
cell.BackColor = grdUserReports.HeaderStyle.BackColor
Next
For Each row As GridViewRow In grdUserReports.Rows
row.BackColor = Color.White
For Each cell As TableCell In row.Cells
If row.RowIndex Mod 2 = 0 Then
cell.BackColor = grdUserReports.AlternatingRowStyle.BackColor
Else
cell.BackColor = grdUserReports.RowStyle.BackColor
End If
cell.CssClass = "textmode"
Next
Next
grdUserReports.RenderControl(hw)
'style to format numbers to string
Dim style As String = " .textmode { } "
Response.Write(style)
Response.Output.Write(sw.ToString())
Response.Flush()
Response.[End]()
End Using
End Sub
this execuates correctly but nothing happens at the end either it is storing my file in excel format in some where in my machine or what else???

Upendra Pratap Shahi · Answer

Read below link- http://www.databaseskill.com/1206748/

Saroj Kumar Sahu · Answer

Hi, I check with your above code but i didnt get any error like above you mentioned.  My code is given below.   Private Sub btnPrintAll_Click(sender As Object, e As System.EventArgs) Handles btnPrintAll.Click Me.grdUserReports.AllowSorting = False Me.grdUserReports.DataBind() Response.Clear() Response.ClearContent() Response.AddHeader("content-disposition", "attachment;filename=sample.xls") Response.Charset = "" Response.ContentEncoding = System.Text.Encoding.Default Response.ContentType = "application/vnd.ms-excel" Me.EnableViewState = False Dim tw As New System.IO.StringWriter() Dim hw As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(tw) Dim myForm As HtmlForm = CType(Page.Master.FindControl("form1"), HtmlForm) myForm.Controls.Add(grdUserReports) myForm.RenderControl(hw) Response.Write(tw.ToString()) Response.Flush() Response.End() End Sub   If u get the above error, please Check the below link http://www.aspdotnet-suresh.com/2011/12/aspnet-controls-collection-cannot-be.html