Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. Excel Conversion Error

Excel Conversion Error

Scheduled Pinned Locked Moved ASP.NET
helpdesignsysadmin
18 Posts 5 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • _ _AK_

    I think there would be some mismatch can you show us the form tag code?

    Apurva Kaushal

    D Offline
    D Offline
    DKalepu
    wrote on last edited by
    #8

    yes, here is my form tag code:

    Company

    Address

    Telephone

    Fax

    Email

    _ 1 Reply Last reply
    0
    • D DKalepu

      yes, here is my form tag code:

      Company

      Address

      Telephone

      Fax

      Email

      _ Offline
      _ Offline
      _AK_
      wrote on last edited by
      #9

      This peace of code works fine for me. I executed that one and is performing well.

      Apurva Kaushal

      D 1 Reply Last reply
      0
      • _ _AK_

        This peace of code works fine for me. I executed that one and is performing well.

        Apurva Kaushal

        D Offline
        D Offline
        DKalepu
        wrote on last edited by
        #10

        hmm...but whats wrong from my side: I executed it again but still the same error persists here is the error:: Control 'myGridView' of type 'GridView' must be placed inside a form tag with runat=server. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: Control 'myGridView' of type 'GridView' must be placed inside a form tag with runat=server. Source Error: Line 63: System.IO.StringWriter stringWrite = new System.IO.StringWriter(); Line 64: System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); Line 65: myGridView.RenderControl(htmlWrite); Line 66: Response.Write(stringWrite.ToString()); Line 67: Response.End();

        D 1 Reply Last reply
        0
        • D DKalepu

          hmm...but whats wrong from my side: I executed it again but still the same error persists here is the error:: Control 'myGridView' of type 'GridView' must be placed inside a form tag with runat=server. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: Control 'myGridView' of type 'GridView' must be placed inside a form tag with runat=server. Source Error: Line 63: System.IO.StringWriter stringWrite = new System.IO.StringWriter(); Line 64: System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); Line 65: myGridView.RenderControl(htmlWrite); Line 66: Response.Write(stringWrite.ToString()); Line 67: Response.End();

          D Offline
          D Offline
          DKalepu
          wrote on last edited by
          #11

          its showing the error at Line 65.

          1 Reply Last reply
          0
          • D DKalepu

            Hi All, I need some help. I'm trying to export Gridview into Excel. But i'm getting the following error! "Control 'myGridView' of type 'GridView' must be placed inside a form tag with runat=server." Here is my Code: protected void BtnExport_Click(object sender, EventArgs e) { Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=FileName.xls"); Response.Charset = ""; // If you want the option to open the Excel file without saving then // comment out the line below // Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/ms-excel.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); myGridView.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End(); } THIS IS THE GRIDVIEW THAT I'M USING:: But my Gridview is already placed in the form only!!!!:((:confused: could any one please help me on

            J Offline
            J Offline
            Jay_se
            wrote on last edited by
            #12

            In order to overcome the error, We have to override the below function. public override void VerifyRenderingInServerForm(Control control) { }

            Regards, Jay :)

            V 1 Reply Last reply
            0
            • D DKalepu

              Hi All, I need some help. I'm trying to export Gridview into Excel. But i'm getting the following error! "Control 'myGridView' of type 'GridView' must be placed inside a form tag with runat=server." Here is my Code: protected void BtnExport_Click(object sender, EventArgs e) { Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=FileName.xls"); Response.Charset = ""; // If you want the option to open the Excel file without saving then // comment out the line below // Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/ms-excel.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); myGridView.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End(); } THIS IS THE GRIDVIEW THAT I'M USING:: But my Gridview is already placed in the form only!!!!:((:confused: could any one please help me on

              V Offline
              V Offline
              Venkatesh Mookkan
              wrote on last edited by
              #13

              DKalepu wrote:

              myGridView.RenderControl(htmlWrite);

              You cannot render the GridView Control into HTML directly. Use DataGrid. May be Jay_se is correct. But I haven't tried that before. We also had this issue before and we solve that using DataGrid. We can used JavaScript get the HTML String of the GridView and do the same.

              Regards, Venkatesh Mookkan. Software Engineer, India My: Website | Yahoo Group | Blog Spot

              J 1 Reply Last reply
              0
              • V Venkatesh Mookkan

                DKalepu wrote:

                myGridView.RenderControl(htmlWrite);

                You cannot render the GridView Control into HTML directly. Use DataGrid. May be Jay_se is correct. But I haven't tried that before. We also had this issue before and we solve that using DataGrid. We can used JavaScript get the HTML String of the GridView and do the same.

                Regards, Venkatesh Mookkan. Software Engineer, India My: Website | Yahoo Group | Blog Spot

                J Offline
                J Offline
                Jay_se
                wrote on last edited by
                #14

                Hi,

                Venkatesh MookkanYou cannot render the GridView Control into HTML directly.

                We Can do Vankat. It works fine too.

                Regards, Jay :)

                V 1 Reply Last reply
                0
                • J Jay_se

                  Hi,

                  Venkatesh MookkanYou cannot render the GridView Control into HTML directly.

                  We Can do Vankat. It works fine too.

                  Regards, Jay :)

                  V Offline
                  V Offline
                  Venkatesh Mookkan
                  wrote on last edited by
                  #15

                  If it works fine, then no problem for me man.. Thanks...

                  Regards, Venkatesh Mookkan. Software Engineer, India My: Website | Yahoo Group | Blog Spot

                  1 Reply Last reply
                  0
                  • D DKalepu

                    Hi All, I need some help. I'm trying to export Gridview into Excel. But i'm getting the following error! "Control 'myGridView' of type 'GridView' must be placed inside a form tag with runat=server." Here is my Code: protected void BtnExport_Click(object sender, EventArgs e) { Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=FileName.xls"); Response.Charset = ""; // If you want the option to open the Excel file without saving then // comment out the line below // Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/ms-excel.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); myGridView.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End(); } THIS IS THE GRIDVIEW THAT I'M USING:: But my Gridview is already placed in the form only!!!!:((:confused: could any one please help me on

                    D Offline
                    D Offline
                    DKalepu
                    wrote on last edited by
                    #16

                    Hi, Thank you very much for the help Jay.. That piece of code solved my problem..... Thank you so much once again to all of you for helping on my problem/ :-D

                    1 Reply Last reply
                    0
                    • J Jay_se

                      In order to overcome the error, We have to override the below function. public override void VerifyRenderingInServerForm(Control control) { }

                      Regards, Jay :)

                      V Offline
                      V Offline
                      Venkatesh Mookkan
                      wrote on last edited by
                      #17

                      Cool stuff man... I will rate this... :)

                      Regards, Venkatesh Mookkan. Software Engineer, India My: Website | Yahoo Group | Blog Spot

                      J 1 Reply Last reply
                      0
                      • V Venkatesh Mookkan

                        Cool stuff man... I will rate this... :)

                        Regards, Venkatesh Mookkan. Software Engineer, India My: Website | Yahoo Group | Blog Spot

                        J Offline
                        J Offline
                        Jay_se
                        wrote on last edited by
                        #18

                        Thanks:-O (For Nellai Website Too) -- modified at 5:45 Wednesday 13th June, 2007

                        Regards, Jay :)

                        1 Reply Last reply
                        0
                        Reply
                        • Reply as topic
                        Log in to reply
                        • Oldest to Newest
                        • Newest to Oldest
                        • Most Votes


                        • Login

                        • Don't have an account? Register

                        • Login or register to search.
                        • First post
                          Last post
                        0
                        • Categories
                        • Recent
                        • Tags
                        • Popular
                        • World
                        • Users
                        • Groups