ASP.Net : Export Gridview in PDF | Neha Sharma

Introduction:

Export your daily report in pdf is daily need for any reporting software or application. The same happened when I was working on a project the project was about to finished but sudden anyhow a requirement came to export whole data/report which is displaying in gridview in to pdf.

I was shocked how to add.. when it’s about to finish, but after many try I got the reply that is here :

Requirement:

The only requirement is to add dll of “ITextSharp”  in to the software  to export  the gridview in pdf.

Code:

In code behind add below name spaces :


using iTextSharp.text;
using iTextSharp.text.pdf;
using iTextSharp.text.html.simpleparser;

Add a gridview and bind that with the database. Add a button to “export in pdf”.

Double click on the button “export in pdf” and write below code there :

Response.ContentType = "application/pdf";

        Response.AddHeader("content-disposition", "attachment;filename=report_grid.pdf");

        Response.Cache.SetCacheability(HttpCacheability.NoCache);

        StringWriter s_w = new StringWriter();

        HtmlTextWriter h_w = new HtmlTextWriter(s_w);

        gvdetails.AllowPaging = false;

        gvdetails.DataBind();

        gvdetails.RenderControl(h_w);

        gvdetails.HeaderRow.Style.Add("width", "15%");

        gvdetails.HeaderRow.Style.Add("font-size", "10px");

        gvdetails.Style.Add("text-decoration", "none");

        gvdetails.Style.Add("font-family", "Arial, Helvetica, sans-serif;");

        gvdetails.Style.Add("font-size", "8px");

        StringReader sr = new StringReader(s_w.ToString());

        Document pdfDoc = new Document(PageSize.A2, 7f, 7f, 7f, 0f);

        HTMLWorker htmlparser = new HTMLWorker(pdfDoc);

        PdfWriter.GetInstance(pdfDoc, Response.OutputStream);

        pdfDoc.Open();

        htmlparser.Parse(sr);

        pdfDoc.Close();

        Response.Write(pdfDoc);

        Response.End();

And add the below override method to override your control because in this case when you click to export gridview in to pdf complier never find your gridview in to the form tag :

public override void VerifyRenderingInServerForm(Control control)

    {

        /* Verifies that the control is rendered */

    }

Now save all work and run the code it ll look better.

For any query or need dll you can commment here.

Thanks

Neha Sharma

Wishing you all a very Happy Women's Day | Neha Sharma

The funny part of Our society,

Is that we call her Mother INDIA,                        

We grab her in feminine dignity and then               

We rape her in colleges,                                      

We burn her in villages,                                       

We attack her in her streets,                                

We murder her in her apartments,                        

We exploit her in her work places and                  

We leave her to die a thousand deaths every moment.

If she works, she is liberal

if she stays at home she will be abused/tortured,                                    

That's how we perceive our women,                  

Don't women make nice subjects for symposiums, neat commemorative dates. 

Don’t make them Flooring material over whom we walk every day. 

The life is not fast forwarding the movie. 

It's about a thought called your original thought. 

A thought that shrieks each time 

when a teenager raped, 

A thought that weeps

when a widow becomes SATI. 

A thought with fire, 

Think by thinkers who are sometimes ashamed to be a human.

With care & love on this International Women's Day!

Thanks.

Take care!!