Hi there,
I am using this code that I have found in the internet to generate excel
output.

        Response.Clear();
        Response.AddHeader("content-disposition",
"attachment;filename=kirim.xls");
        Response.Charset = "";

        // If you want the option to open the Excel file without saving than
        // comment out the line below
        // Response.Cache.SetCacheability(HttpCacheability.NoCache);

        Response.Cache.SetCacheability(HttpCacheability.NoCache);
        Response.ContentType = "application/vnd.xls";

        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite =
        new HtmlTextWriter(stringWrite);

        //gv.RenderControl(htmlWrite);
        this.RenderControl(htmlWrite);

        Response.Write(stringWrite.ToString());
        Response.End();


But I've got this error (Exception) bellow when Response.End() issue.
"Unable to evaluate expression because the code is optimized or a native
frame is on top of the call stack."

How to correct this issue?

Regards,
Gun

>        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
>        System.Web.UI.HtmlTextWriter htmlWrite =
>        new HtmlTextWriter(stringWrite);
>
>        //gv.RenderControl(htmlWrite);
>        this.RenderControl(htmlWrite);


It should not be this.RenderControl but gridView.RenderControl(htmlWrite)

It's the GridView that has to be rendered and not the page (this)!!!

-- 
Happy Hacking,
Gaurav Vaish | www.mastergaurav.com
www.edujini-labs.com
http://eduzine.edujini-labs.com
-----------------------------------------

Thank you for your reply

change to this

>>        gv.RenderControl(htmlWrite);
>>        //this.RenderControl(htmlWrite);


I have this error when rendering GridView
"Control 'gv' of type 'GridView' must be placed inside a form tag with 
runat=server."


    <form id="frmRencanaKirim" runat="server">
        <div>
                <asp:GridView ID="gv" runat="server"
                    AutoGenerateColumns="False"
                    ForeColor="#333333"
                    CellPadding="2"
                    AllowPaging="false"
                    ShowFooter="True">
                    <HeaderStyle BackColor="#507CD1"
                        Font-Bold="True" ForeColor="White"/>
                    <FooterStyle BackColor="#507CD1"
                        Font-Bold="True" ForeColor="White" />
                    <RowStyle BackColor="#EFF3FB" Height="25px" />
                    <AlternatingRowStyle BackColor="White" />
                    <Columns>
                    ...
                    </Columns>
                </asp:GridView>
            <asp:Label ID="lbMessage" runat="server" Text=" " 
ForeColor="Red" Visible="False" />
        </div>
    </form>


What's wrong?


"MasterGaurav (www.edujini-labs.com)"  
wrote in message news:uU64aJ3pHHA.4196@TK2MSFTNGP06.phx.gbl...

>>        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
>>        System.Web.UI.HtmlTextWriter htmlWrite =
>>        new HtmlTextWriter(stringWrite);
>>
>>        //gv.RenderControl(htmlWrite);
>>        this.RenderControl(htmlWrite);
>
> It should not be this.RenderControl but gridView.RenderControl(htmlWrite)
>
> It's the GridView that has to be rendered and not the page (this)!!!
>
> -- 
> Happy Hacking,
> Gaurav Vaish | www.mastergaurav.com
> www.edujini-labs.com
> http://eduzine.edujini-labs.com
> -----------------------------------------
>
> 

> I have this error when rendering GridView
> "Control 'gv' of type 'GridView' must be placed inside a form tag with 
> runat=server."


Ensure that you override the method "VerifyRenderingInServerForm" with no 
code:

public override void VerifyRenderingInServerForm(Control control)

{

//don't throw any exception!

}



-- 
Happy Hacking,
Gaurav Vaish | www.mastergaurav.com
www.edujini-labs.com
http://eduzine.edujini-labs.com
-----------------------------------------

I have tried follow your suggestion...

After all, it back to original issue.

"Unable to evaluate expression because the code is optimized or a native
frame is on top of the call stack."


"MasterGaurav (www.edujini-labs.com)"  
wrote in message news:%23PCTRU$pHHA.4120@TK2MSFTNGP06.phx.gbl...

>> I have this error when rendering GridView
>> "Control 'gv' of type 'GridView' must be placed inside a form tag with 
>> runat=server."
>
> Ensure that you override the method "VerifyRenderingInServerForm" with no 
> code:
>
> public override void VerifyRenderingInServerForm(Control control)
>
> {
>
> //don't throw any exception!
>
> }
>
>
>
> -- 
> Happy Hacking,
> Gaurav Vaish | www.mastergaurav.com
> www.edujini-labs.com
> http://eduzine.edujini-labs.com
> ----------------------------------------- 
>
> 

>I have tried follow your suggestion...
>
> After all, it back to original issue.
>
> "Unable to evaluate expression because the code is optimized or a native
> frame is on top of the call stack."



Can you put up the entire code for download somewhere?

-- 
Happy Hacking,
Gaurav Vaish | www.mastergaurav.com
www.edujini-labs.com
http://eduzine.edujini-labs.com
-----------------------------------------

I have, didn't I? On my first post.

Error occurred when issue Response.End();
No matter what data that I would like to show in gridview.
Regards,
Gun

"MasterGaurav (www.edujini-labs.com)"  
wrote in message news:ecItI%233qHHA.4180@TK2MSFTNGP04.phx.gbl...

> >I have tried follow your suggestion...
>>
>> After all, it back to original issue.
>>
>> "Unable to evaluate expression because the code is optimized or a native
>> frame is on top of the call stack."
>
>
> Can you put up the entire code for download somewhere?
>
> -- 
> Happy Hacking,
> Gaurav Vaish | www.mastergaurav.com
> www.edujini-labs.com
> http://eduzine.edujini-labs.com
> -----------------------------------------
>
> 

Ah! Forgot about it :)


ok.... I have a code that looks something liks this:

 protected void LinkButton1_Click(object sender, EventArgs e)
 {
  Response.ClearHeaders();
  Response.Clear();

  Response.Charset = "";
  Response.ContentType = "application/vnd.ms-excel";
  Response.AddHeader("Content-Disposition", "attachment; 
filename=Customers.xls");

  StringWriter strWriter = new StringWriter();
  HtmlTextWriter hwriter = new HtmlTextWriter(strWriter);
  GridView1.RenderControl(hwriter);
  Response.Write(strWriter.ToString());
  Response.End();

 }


 public override void VerifyRenderingInServerForm(Control control)
 {
  //don't throw any exception!
 }




-- 
Happy Hacking,
Gaurav Vaish | www.mastergaurav.com
www.edujini-labs.com
http://eduzine.edujini-labs.com
-----------------------------------------


"Gunawan"  wrote in message 
news:etai2H%23qHHA.3456@TK2MSFTNGP02.phx.gbl...

>I have, didn't I? On my first post.
>
> Error occurred when issue Response.End();
> No matter what data that I would like to show in gridview.
> Regards,
> Gun
>
> "MasterGaurav (www.edujini-labs.com)" 
>  wrote in message 
> news:ecItI%233qHHA.4180@TK2MSFTNGP04.phx.gbl...
>> >I have tried follow your suggestion...
>>>
>>> After all, it back to original issue.
>>>
>>> "Unable to evaluate expression because the code is optimized or a native
>>> frame is on top of the call stack."
>>
>>
>> Can you put up the entire code for download somewhere?
>>
>> -- 
>> Happy Hacking,
>> Gaurav Vaish | www.mastergaurav.com
>> www.edujini-labs.com
>> http://eduzine.edujini-labs.com
>> -----------------------------------------
>>
>>
>
>