simple way to export gridview as pdf?

Use ITextSharp, refer below code.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
//need to import namespaces
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.IO;
using iTextSharp.text;
using iTextSharp.text.html.simpleparser;
using iTextSharp.text.pdf;
using iTextSharp.tool.xml;
namespace GridviewExportPdf
{
public partial class ExportToPdf : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
}
}
public override void VerifyRenderingInServerForm(Control control)
{
//base.VerifyRenderingInServerForm(control);
}
//Binding The GridView
public void BindGrid()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from tblEmployee",con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
gridExportToPdf.DataSource = ds;
gridExportToPdf.DataBind();
}
}
//Implementing Paging in GridView
protected void gridExportToPdf_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gridExportToPdf.PageIndex = e.NewPageIndex;
BindGrid();
}
// create the following Method to Export the Grid view to PDF as
//Below is the code to Export GridView to PDF file with Paging enabled.
private void ExportGridToPDF()
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=GridExporttoPdf.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
//GridView is again popoulated after set allowpaging is false
gridExportToPdf.AllowPaging = false;
this.BindGrid();
gridExportToPdf.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A2, 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
//Now double click on Export button and call the above function on "onclick"as
protected void btnExportToPdf_Click(object sender, EventArgs e)
{
ExportGridToPDF();
}
}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
use ITextSharp , it is the simplest.
https://www.aspsnippets.com/Articles/Export-GridView-to-PDF-with-Header-Repeated-on-each-Page-in-ASPNet.aspx
Sapna Girish5y ago
Hi, the following link might be helpful.

https://www.e-iceblue.com/Tutorials/Spire.DataExport/Spire.DataExport-Program-Guide/How-to-Export-DataTable-to-PDF.html
Rajanikant Hawaldar5y ago
Use ITextSharp, refer below code.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
//need to import namespaces
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.IO;
using iTextSharp.text;
using iTextSharp.text.html.simpleparser;
using iTextSharp.text.pdf;
using iTextSharp.tool.xml;
namespace GridviewExportPdf
{
    public partial class ExportToPdf : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString);
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindGrid();
            }
        }
        public override void VerifyRenderingInServerForm(Control control)
        {
            //base.VerifyRenderingInServerForm(control);
        }
       //Binding The GridView
        public void BindGrid()
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("select * from tblEmployee",con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            con.Close();
            if (ds.Tables[0].Rows.Count > 0)
            {
                gridExportToPdf.DataSource = ds;
                gridExportToPdf.DataBind();
            }
        }
       //Implementing Paging in GridView
        protected void gridExportToPdf_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            gridExportToPdf.PageIndex = e.NewPageIndex;
            BindGrid();
        }
     // create the following Method to Export the Grid view to PDF as
     //Below is the code to Export GridView to PDF file with Paging enabled.
         private void ExportGridToPDF()
         {
              Response.ContentType = "application/pdf";
              Response.AddHeader("content-disposition", "attachment;filename=GridExporttoPdf.pdf");
              Response.Cache.SetCacheability(HttpCacheability.NoCache);
              StringWriter sw = new StringWriter();
              HtmlTextWriter hw = new HtmlTextWriter(sw);
              //To Export all pages
              //GridView is again popoulated after set allowpaging is false
              gridExportToPdf.AllowPaging = false;
              this.BindGrid();
               gridExportToPdf.RenderControl(hw);
                StringReader sr = new StringReader(sw.ToString());
                Document pdfDoc = new Document(PageSize.A2, 10f, 10f, 10f, 0f);
                HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
                PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
                pdfDoc.Open();
                htmlparser.Parse(sr);
                pdfDoc.Close();
                Response.Write(pdfDoc);
                Response.End();
             }
       //Now double click on Export button and call the above function on "onclick"as
        protected void btnExportToPdf_Click(object sender, EventArgs e)
        {
            ExportGridToPDF();
        }
    }
}