Howto resolve the error in response.end

Question

5.00/5 (1 vote)

See more:

Hi,

In my project I am exporting excel file to view some data's. When I am clicking the button it throws an error as follows(The error is thrown in the line Response.End):

[System.Threading.ThreadAbortException] = {Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack.}

Here is the Code:

public static void ExportDataTableToCSV(DataTable dataTable, string CSVFileName)
    {
        System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
        System.Web.HttpContext context = HttpContext.Current;
        context.Response.Clear();
        context.Response.ContentType = "text/csv";
        context.Response.AddHeader("Content-Disposition", "attachment; filename=" + CSVFileName + ".csv");
        //Write a row for column names
        foreach (DataColumn dataColumn in dataTable.Columns)
            context.Response.Write(dataColumn.ColumnName + ",");
        context.Response.Write(Environment.NewLine);
        //Write one row for each DataRow
        foreach (DataRow dataRow in dataTable.Rows)
        {
            for (int dataColumnCount = 0; dataColumnCount < dataTable.Columns.Count; dataColumnCount++)
                context.Response.Write(dataRow[dataColumnCount].ToString() + ",");
            context.Response.Write(Environment.NewLine);
        }
        response.End();   //Here I am getting the error

}

Can anyone help me to solve this issue.

Thanks in Advance

Posted 26-Jul-11 0:59am

Member 7946563

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Ankur^\m/ · Answer 1 · 2011-07-26T01:23:00

I am quoting the cause and resolution from Microsoft Support[^] site -

CAUSE:

The Response.End method ends the page execution and shifts the execution to the Application_EndRequest event in the application's event pipeline. The line of code that follows Response.End is not executed.

This problem occurs in the Response.Redirect and Server.Transfer methods because both methods call Response.End internally.

RESOLUTION:

To work around this problem, use one of the following methods:

    For Response.End, call the HttpContext.Current.ApplicationInstance.CompleteRequest method instead of Response.End to bypass the code execution to the Application_EndRequest event.
    For Response.Redirect, use an overload, Response.Redirect(String url, bool endResponse) that passes false for the endResponse parameter to suppress the internal call to Response.End. For example:

      Response.Redirect ("nextpage.aspx", false);
    						
    If you use this workaround, the code that follows Response.Redirect is executed.
    For Server.Transfer, use the Server.Execute method instead.

By the way, I found this USEFUL link by Googling for your error message. If you need more discussion you can always use the Google search link[^]

Hope this helps!