Export gridview data to a excel sheet is giving error

Question

I have a asp.net application where in i am displaying a grid view whose code is shown below

 <center><asp:GridView ID="GridView1" runat="server" 
        RowStyle-HorizontalAlign="Center" CellPadding="4" ForeColor="#333333" 
         GridLines="None">
 <AlternatingRowStyle BackColor="White" />
    <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
    <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
    <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<RowStyle HorizontalAlign="Center" BackColor="#FFFBD6" ForeColor="#333333"></RowStyle>
    <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
    <SortedAscendingCellStyle BackColor="#FDF5AC" />
    <SortedAscendingHeaderStyle BackColor="#4D0000" />
    <SortedDescendingCellStyle BackColor="#FCF6C0" />
    <SortedDescendingHeaderStyle BackColor="#820000" />
    </asp:GridView>
 </center>
 <center> <table>
 <tr>
 <td>
    <asp:Button ID="btnWordConvert" runat="server" Text="Button" 
        onclick="btnWordConvert_Click" />
</td>
</tr>
</table>
</center>

in cs

 protected void btnWordConvert_Click(object sender, EventArgs e)
{
    GridView1.AllowPaging = false;
    GridView1.DataBind();
    Response.ClearContent();
    Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.doc"));
    Response.Charset = "";
    Response.ContentType = "application/ms-word";
    StringWriter sw = new StringWriter();
    HtmlTextWriter htw = new HtmlTextWriter(sw);
    GridView1.RenderControl(htw);
    Response.Write(sw.ToString());
    Response.End();

}

i am getting error on GridView1.RenderControl(htw); line and the error is Control 'ctl00_ContentPlaceHolder1_GridView1' of type 'GridView' must be placed inside a form tag with runat=server. Any help are appreciated.

the error tells itself the solution. Place your gridview inside the form tag — Shaharyar
– Shaharyar, Commented Dec 26, 2013 at 8:48

Semih Yagcioglu · Accepted Answer · 2013-12-26 08:55:34Z

1

The reason you are getting this is, a server control is rendered outside of a form tag by calling GridView.RenderControl(HtmlTextWriter).

You could avoid this by overriding VerifyRenderingInServerForm.

Have a look at this.

answered Dec 26, 2013 at 8:55

Semih Yagcioglu

4,1111 gold badge29 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shreyas Achar Over a year ago

Its downloading.But when i open the downloaded document a File Coversion window is been opening in Microsoft word.The document shows only <div> </div>

Semih Yagcioglu Over a year ago

It is because you are saving your response to an ms-word content type. If you want to save it as excel, you should change it to the correct content type.

Kumod Singh · Accepted Answer · 2013-12-26 09:00:20Z

1

Put your code inside form tag.

<form id="form1" runat="server">

   //put your code here
</form>

answered Dec 26, 2013 at 9:00

Kumod Singh

2,1631 gold badge16 silver badges18 bronze badges

Comments

Saritha.S.R · Accepted Answer · 2013-12-26 08:52:55Z

0

Please make sure that your gridview is inside form tag.

 <form id="form1" runat="server">
    <asp:GridView ID="GridView1" runat="server" 
        RowStyle-HorizontalAlign="Center" CellPadding="4" ForeColor="#333333" 
         GridLines="None">
                        ... ... ... 
    </asp:GridView>
 </form>

answered Dec 26, 2013 at 8:52

Saritha.S.R

8002 gold badges6 silver badges19 bronze badges

2 Comments

Shreyas Achar Over a year ago

i tried that thing and its giving error as page can use only one server side tag

Saritha.S.R Over a year ago

are u using master page approach

suraj mahajan · Accepted Answer · 2015-07-20 10:43:46Z

0

put following method

public override void VerifyRenderingInServerForm(Control control)
{
      /* Verifies that the control is rendered */
}

answered Jul 20, 2015 at 10:43

suraj mahajan

9111 gold badge12 silver badges21 bronze badges

Collectives™ on Stack Overflow

Export gridview data to a excel sheet is giving error

4 Answers 4

2 Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related