Export datagridview data to pdf

Question

In my application i want to export datagridview data to pdf format using itextsharp dll and i dont have any images in it. can any1 help me on this

santhosh kumar · Answer

THanks but can u send me the full coding of it.

Piyush Parikh · Answer

Mem now if U have Solution please Share it or Mail me pparikh1989@gmail.com Thanks

Ankit Patel · Answer

try this code...100% Successfully Run... try { ExportToPDF exporter = new ExportToPDF(this.grid_item_view_stock_details); exporter.FileExtension = "pdf"; exporter.FitToPageWidth = true; string fileName = "D:\" + "Stock_Detail_" + DateTime.Now.ToString("dd MMM yyy"); int i = 1; while (File.Exists(fileName + "(" + i.ToString() + ")" + ".pdf")) { i++; } fileName += "(" + i.ToString() + ")" + ".pdf"; exporter.ExportVisualSettings = true; exporter.PageTitle = "Stock Detail"; exporter.RunExport(fileName); DialogResult Result = RadMessageBox.Show("File exported to following folder.
" + fileName + "
Do you want open?", "Stock Detail", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (Result == DialogResult.Yes) { Process.Start(fileName); } } catch (Exception ex) { } }

Sweety · Answer

I think this for the webapplication but i need for windows application where i'm using datagrid not the gridview. please i searched in net aslo but im not getting it

Soft Corner · Answer

Hi, try this code : using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data.SqlClient; using System.Web.UI.WebControls; using System.IO; using System.Web.UI.HtmlControls; using System.Web.UI; using iTextSharp.text; using iTextSharp.text.pdf; using iTextSharp.text.html.simpleparser; namespace ItextPdf.Web.Model { public class GetTable { public void getpdf () { string strcon = @"Data Source=.\SQLEXPRESS;Initial Catalog=temp;Integrated Security=true;"; SqlConnection con = new SqlConnection(strcon); con.Open(); string qry = @"select [iEmpId],[vchEmpName],[vchCity],[vchState],[vchDesignation] from EmployeeDetails with(nolock)"; SqlCommand cmd = new SqlCommand(qry, con); GridView GridView1 = new GridView(); GridView1.Height = 100; GridView1.Width = 100; SqlDataReader reader = cmd.ExecuteReader(); GridView1.DataSource = reader; GridView1.DataBind(); con.Close(); HtmlForm form = new HtmlForm(); form.Controls.Add(GridView1); StringWriter sw = new StringWriter(); HtmlTextWriter hTextWriter = new HtmlTextWriter(sw); form.Controls[0].RenderControl(hTextWriter); string html = sw.ToString(); Document Doc = new Document(); PdfWriter.GetInstance (Doc, new FileStream(Environment.GetFolderPath (Environment.SpecialFolder.Desktop) + "\PdfSample.pdf", FileMode.Create)); Doc.Open(); using (TextReader sReader = new StringReader(html.ToString())) { List list = HTMLWorker.ParseToList(sReader, new StyleSheet()); foreach (IElement elm in list) { Doc.Add(elm); } } Doc.Close(); string Path = Environment.GetFolderPath (Environment.SpecialFolder.Desktop) + "\PdfSample.pdf"; } } }

Sweety · Answer

Its throwing error like htmlparser doesnot contain in the current context and even this response keyword doesnt support for windows form

pooja shete · Answer

Add following lines as reference on page Imports Imports Imports iTextSharp.text.pdf iTextSharp.text.html.simpleparser iTextSharp.text button click code.. Response.ContentType = "application/pdf" Response.AddHeader( "content-disposition" , "attachment;filename=VesselWiseReport.pdf" ) Response.Cache.SetCacheability(HttpCacheability.NoCache) Dim StringWrite As New System.IO.StringWriter() Dim htmlWrite As New HtmlTextWriter(StringWrite) DistTbl.RenderControl(htmlWrite) Dim sr As New StringReader(StringWrite.ToString()) Dim pdfDoc As New Document(PageSize.A4, 10.0F, 10.0F, 10.0F, 0.0F) Dim htmlparser As New HTMLWorker(pdfDoc) PdfWriter.GetInstance(pdfDoc, Response.OutputStream) pdfDoc.Open() htmlparser.Parse(sr) pdfDoc.Close() Response.Write(pdfDoc) Response.End() iTextSharp.text.pdfiTextSharp.text.html.simpleparseriTextSharp.text

Export datagridview data to pdf

Answers (7)