Export Grid view to PDF

How to Export Grid view to PDF?

Gridview data is Export to PDF document with help of free itextsharp reference.

Download itextsharp.dll file from below link

http://sourceforge.net/projects/itextsharp/

After download add this itextsharp.dll reference into your project

Select Project Name in solution explorer ->Right click select add reference ->select Browse tab->and choose your itextsharp.dll location click Ok button. Then write below code in your web page.

Client Side

I placed one Grid View and button under form tag

<asp:GridView ID="GridView1" runat="server">

</asp:GridView><br />

<asp:Button ID="btnExport" runat="server" Text="Export to PDF"

            onclick="btnExport_Click"/>

Server Side

using iTextSharp.text;

using iTextSharp.text.pdf;

using System.Data;

using System.IO;

using System.Data.SqlClient;

public partial class Export_PDF : System.Web.UI.Page

{

    //Server connection detail

    SqlConnection sqlcon = new SqlConnection(@"Server=RAVI\SQLEXPRESS;database=test;uid=xxxx;pwd=yyyy;");

    SqlCommand sqlcmd = new SqlCommand();

    DataTable dt = new DataTable();

    SqlDataAdapter da = new SqlDataAdapter();

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!Page.IsPostBack)

        {

            BindGrid();

        }

    }

    void BindGrid()

    {

        sqlcmd = new SqlCommand("select * from emp1", sqlcon);

        sqlcon.Open();

        da = new SqlDataAdapter(sqlcmd);

        da.Fill(dt);

        //store this data table value in session for export as pdf in future

        Session["Export_Table"] = dt;

        GridView1.DataSource = dt;

        GridView1.DataBind();

        sqlcon.Close();

    }

    protected void btnExport_Click(object sender, EventArgs e)

    {      

        if (Session["Export_Table"] != null)

        {

            ExportToPdf(Session["Export_Table"] as DataTable);

        }

        else {

            Response.Write("No data to Export!");

        }

    }

    public void ExportToPdf(DataTable ExDataTable)

    {

        //Here set page size as A4

       

        Document pdfDoc = new Document(PageSize.A4, 10, 10, 10, 10);

        try

        {

            PdfWriter.GetInstance(pdfDoc, System.Web.HttpContext.Current.Response.OutputStream);

            pdfDoc.Open();

          

            //Header Logo path

            string imageFilePath = Server.MapPath("~/images/Header.jpg");

            iTextSharp.text.Image image = iTextSharp.text.Image.GetInstance(imageFilePath);

            //Set Height and width for your Image Header

            image.ScaleToFit(80f, 60f);

            //Here I give space before image

            image.SpacingBefore = 0f;

            //Here I give space after image

            image.SpacingAfter = 1f;

            image.Alignment = Element.HEADER;

            //Add Header image to PDF Document

            pdfDoc.Add(image);

            //Set Font Properties for PDF File

            Font fnt = FontFactory.GetFont("Times New Roman", 12);

            DataTable dt = ExDataTable;

            if (dt != null)

            {

               

                PdfPTable PdfTable = new PdfPTable(dt.Columns.Count);

                PdfPCell PdfPCell = null;

               

                //Here we create PDF file tables

                for (int rows = 0; rows < dt.Rows.Count; rows++)

                {

                    for (int column = 0; column < dt.Columns.Count; column++)

                    {

                        PdfPCell = new PdfPCell(new Phrase(new Chunk(dt.Rows[rows][column].ToString(), fnt)));

                        PdfTable.AddCell(PdfPCell);

                    }

                }

                // Finally Add pdf table to the document

                pdfDoc.Add(PdfTable);

            }

            pdfDoc.Close();

           

            Response.ContentType = "application/pdf";

           

            //Set default file Name as current datetime

            Response.AddHeader("content-disposition", "attachment; filename=" + DateTime.Now.ToString("yyyyMMdd") + ".pdf");

            System.Web.HttpContext.Current.Response.Write(pdfDoc);

            Response.Flush();

            Response.End();

         

        }     

        catch (Exception ex)

        {

            Response.Write(ex.ToString());

        }

    }  

  

}