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.
  • 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