Export the data from DataGridView to Pdf

Question

I want to Export the data from DataGridView to Pdf file with column headings in windows application. Please, Can anyone help with sample code

Dhara Patel · Answer

Hi, try the following example :   Export GridView in Excel https://www.c-sharpcorner.com/UploadFile/0c1bb2/export-gridview-to-excel/ Export gridview in doc/pdf https://www.c-sharpcorner.com/uploadfile/eb5fab/export-data-in-Asp-Net-gridview-to-doc-gridview-to-excel-gridview-to-pdf/

Mageshwaran R · Answer

Hi, Please refer the below link, it might helps you https://www.youtube.com/watch?v=VhsGGLREqu8

Leon D · Answer

You can install Spire.Pdf.dll from NuGet and use code like below to simply export datagridview to pdf. private   void  button1_Click( object  sender, EventArgse)   {            //create a pdf document        PdfDocument pdf =  new  PdfDocument();        //add a page        PdfPageBase page =pdf.Pages.Add();            //create a table        PdfTable table =  new  PdfTable();                     //export datagridview to table        table.DataSource = dataGridView1.DataSource;            //show header        table.Style.ShowHeader =  true ;                                        //set cell padding        table.Style.CellPadding = 2;            //set table layout        PdfTableLayoutFormat tableLayout =  new  PdfTableLayoutFormat();       tableLayout.Break = PdfLayoutBreakType.FitElement;       tableLayout.Layout = PdfLayoutType.Paginate;           table.BeginRowLayout += newBeginRowLayoutEventHandler(table_BeginRowLayout);            //draw table to pdf page        table.Draw(page,  new  RectangleF(10, 50, 300, 300), tableLayout);                                             pdf.SaveToFile( "Output.pdf" );   }   //font and text alignment    private   static   void  table_BeginRowLayout(objectsender, BeginRowLayoutEventArgs args)  {       PdfCellStyle cellstyle =  new  PdfCellStyle();       cellstyle.StringFormat =  new  PdfStringFormat(PdfTextAlignment.Center);       cellstyle.Font =  new  PdfTrueTypeFont( new  Font( "Arial Unicode MS" , 9f),  true );       args.CellStyle = cellstyle;   }

Uehara Ayaka · Answer

Besides using iTextsharp, you could use following brilliant way to export data from DataGridView to PDF: http://www.e-iceblue.com/Tutorials/Spire.DataExport/Spire.DataExport-Program-Guide/How-to-Export-DataTable-to-PDF.html Step 1: Load data from date source to DataGridView Step 2: Export data from DataGridView to PDF

Imtiyaz Ansari · Answer

Hello Patil...   Try This   Download the dll of itextSharp.dll using iTextSharp.text; using iTextSharp.text.pdf; using System.IO; private void btnExport_Click(object sender, EventArgs e) { Document doc = new Document(iTextSharp.text.PageSize.LETTER, 10, 10, 42, 35); PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream("d:\Test.pdf", FileMode.Create)); doc.Open();//Open Document to write Paragraph paragraph = new Paragraph("data Exported From DataGridview!"); //Create table by setting table value Table t1 = new Table(2); DataTable dt = (DataTable)dataGridView1.DataSource; //Create Table Header Cell cid = new Cell("ID"); Cell cname = new Cell("Name"); t1.AddCell(cid); t1.AddCell(cname); foreach (DataGridViewRow rows in dataGridView1.Rows) { string id = dataGridView1.Rows[rows.Index].Cells["empid"].Value.ToString(); string name = dataGridView1.Rows[rows.Index].Cells["ename"].Value.ToString(); //Create Cells Cell c2 = new Cell(id); Cell c1 = new Cell(name); //Adding cells t1.AddCell(c1); t1.AddCell(c2); } doc.Add(paragraph); doc.Add(t1); doc.Close(); //Close document // MessageBox.Show("PDF Created!"); } /// Reference :-http://www.aspsnippets.com/Articles/Export-Windows-Forms-DataGridView-to-PDF-using-iTextSharp-C-and-VBNet.aspx

Rajeesh Menoth · Answer

Hi,   check the following example :   http://www.aspsnippets.com/Articles/Export-Windows-Forms-DataGridView-to-PDF-using-iTextSharp-C-and-VBNet.aspx    https://social.msdn.microsoft.com/Forums/en-US/e36c26d3-df8d-4be1-86f6-7e89f75e57f7/export-datagridview-data-to-pdf-file?forum=winforms