simple way to export gridview as pdf?

Question

Is there any simple way to export gridview as pdf?

Sachin Singh · 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 Girish · Answer

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 Hawaldar · Answer

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(); } } }

simple way to export gridview as pdf?

Answers (3)