Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET4.0
Hi,
For Exporting grid view to excel file i use following code
 
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition","attachment;filename=g.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter ht = new HtmlTextWriter(sw);
gvDisplay.AllowPaging = false;
gvDisplay.DataBind();
gvDisplay.RenderControl(ht);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
but following error occurred when using Master page on line
GridView1.RenderControl(ht);
 
Control 'cntPlcHolder_gvDisplay 'GridView' must be placed inside a form tag with runat=server.
 
pls help me fast
Posted 10-Feb-12 20:14pm
Edited 10-Feb-12 21:07pm
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

just write following method
public override void VerifyRenderingInServerForm(Control control)
    {
 
    }
  Permalink  
Comments
mariamg at 3-Apr-12 8:12am
   
Hi,
I Write this above Code
but following error
[System.Threading.ThreadAbortException] = {Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack.}
then
I deleted a Line of Code "Response.End();"
And
Added HttpContext.Current.ApplicationInstance.CompleteRequest();
It is Passed without error but it is not working
Nilesh Patil Kolhapur at 7-Apr-12 6:31am
   
it works properly for me
SURESH MOGUDALA at 23-Aug-14 5:36am
   
Where the gridview located within the Update Panel or Outside the Update Panel ?
 
If within the Update Panel You need to add Trigger...
like
 
<asp:UpdatePanel ID="GridView1" runat="server" >

//gridview details
 

<Triggers>
//Button Id (means ExportBtn)
<asp:PostBackTrigger ControlID="ButtonId" />
</Triggers>

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 520
1 Maciej Los 290
2 Richard MacCutchan 265
3 BillWoodruff 265
4 Suraj Sahoo | Coding Passion 155
0 OriginalGriff 8,764
1 Sergey Alexandrovich Kryukov 7,437
2 DamithSL 5,639
3 Maciej Los 5,279
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web03 | 2.8.1411028.1 | Last Updated 25 May 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100