Export to Excel Gridview in master pages

Question

0.00/5 (No votes)

See more:

Hi All,

I have requirement i.e export to excel gridview data in the master pages. While i am trying to export i am getting sys.webforms.pagerequestmanagerparsererrorexception error. Any one please help me out regarding this issue. I have tried in different ways like as follows
1.

DataTable dt = BindCompanies();
        string attachment = "attachment; filename=Employee.xls";
        Response.ClearContent();
        Response.AddHeader("content-disposition", attachment);
        Response.ContentType = "application/vnd.ms-excel";
        string tab = "";
        foreach (DataColumn dc in dt.Columns)
        {
            Response.Write(tab + dc.ColumnName);
            tab = "\t";
        }
        Response.Write("\n");
        int i;
        foreach (DataRow dr in dt.Rows)
        {
            tab = "";
            for (i = 0; i < dt.Columns.Count; i++)
            {
                Response.Write(tab + dr[i].ToString());
                tab = "\t";
            }
            Response.Write("\n");
        }
        Response.End();

2.

string attachment = "attachment; filename=Export.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
// Create a form to contain the grid
HtmlForm frm = new HtmlForm();
gv.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(gv);
frm.RenderControl(htw);

//GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();

Regards,
Jeevan.

Posted 3-Nov-11 2:15am

Jeevanrao

Add a Solution

3 solutions

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)

Tejas Vaishnav · Answer 1 · 2011-11-03T02:43:00

C#

protected void Export2Excel()
{
try
{
    this.GridView1.AllowPaging = false;
    this.GridView1.AllowSorting = false;
    this.GridView1.EditIndex = -1;

    // Let's bind data to GridView
    this.BindData();

    // Let's output HTML of GridView
    Response.Clear();
    Response.ContentType = "application/vnd.xls";
    Response.AddHeader("content-disposition",
            "attachment;filename=MyList.xls");
    Response.Charset = "";
    StringWriter swriter = new StringWriter();
    HtmlTextWriter hwriter = new HtmlTextWriter(swriter);
    GridView1.RenderControl(hwriter);
    Response.Write(swriter.ToString());
    Response.End();
}
catch (Exception exe)
{
    throw exe;
}

}

use this code and try it it will work for me...

and also take care that you need not put your grid in side a update panel or it will resulted in error like this...

C#

Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server.

Sarvesh Kumar Gupta · Answer 2 · 2012-01-24T06:47:00

Solution 3

Hi use below link:

Export to Excel from GridView in C#[^]

Posted 24-Jan-12 6:47am

Sarvesh Kumar Gupta

Md. Rashim Uddin · Answer 3 · 2011-11-03T02:44:00

Solution 2

Could you please go through the link [^]. This is a very handy in this case.

Posted 3-Nov-11 2:44am

Md. Rashim Uddin