• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 625
  • Last Modified:

datagrid to excel

Hi,

I am trying to export a datagrid to an excel sheet. I found this code at the following location:http://codebetter.com/blogs/darrell.norton/archive/2004/02/12/7154.aspx

 ' Set the content type to Excel
        Response.ContentType = "application/vnd.ms-excel"

        'Turn off the view state
        Me.EnableViewState = False

        'Remove the charset from the Content-Type header
        Response.Charset = String.Empty

        Dim myTextWriter As New System.IO.StringWriter
        Dim myHtmlTextWriter As New System.Web.UI.HtmlTextWriter(myTextWriter)

        'Get the HTML for the control
        dg_disp.RenderControl(myHtmlTextWriter)

        'Write the HTML to the browser
        Response.Write(myTextWriter.ToString())

        'End the response
        Response.End()

The problem is that I have a checkbox in my datagrid and I get the following error when I run it:
Control 'dg_disp__ctl2_cbSelect' of type 'CheckBox' must be placed inside a form tag with runat=server.

If I remove the checkbox it will export the data. Does anyone know of a way that I can export the rest of the data in the grid without exporting the checkbox? I would appreciate the help. Thank you!
0
savache27
Asked:
savache27
  • 4
  • 3
1 Solution
 
skiltzCommented:
I've had this error myself and fot the life of me can't remeber excatly the issue.  Have a read through this.

http://support.microsoft.com/default.aspx?scid=kb;en-us;317719

compare with your code...must be something different.

Thanks,
Matthew
0
 
skiltzCommented:
Actually add this to your code behind.

Public Overrides Sub VerifyRenderingInServerForm(ByVal control As
Control)

End Sub
0
 
savache27Author Commented:
Okay, I'm sorry, but where do I need to put this exactly. I tried to place it in my code behind and it said:
sub VerifyRenderingInServerForm shadows an overloadable member declared in the base class "Page". If you want to overload the base method, this method must be declared 'Overloads'.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
skiltzCommented:
make sure format the line correct eg


Public Overrides Sub VerifyRenderingInServerForm(ByVal control As Control)
end sub
0
 
savache27Author Commented:
AWESOME!! Thank you so much!!! Now I've just got to go figure out some code to get it to only export the rows that are checked. Thanks again for the help!
0
 
skiltzCommented:
Open  a new questions and I'll help with the checkbox stuff..
0
 
savache27Author Commented:
I would appreciate that! I have opened a new question called datagrid to excel checkbox. Thanks again for the previous help!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now