troubleshooting Question

Export Grid view to PDF with specific table width

Avatar of AZZA-KHAMEES
AZZA-KHAMEESFlag for Bahrain asked on
.NET ProgrammingC#ASP.NET
4 Comments1 Solution2454 ViewsLast Modified:
Hi Experts
i am facing a problem in exporting to PDF since the grid view contain an Arabic text, so i changed my code and it working, the problem is the table was very small to handle the content, how can i change to width? and how can i export the same look and feel of the grid view to the PDF, also is it possible to export it as landscape document

        DataTable dt = GetData(SecCode, DirCode);
        GridView1.DataSource = dt;

        try
        {
            
            iTextSharp.text.pdf.PdfPTable table = new iTextSharp.text.pdf.PdfPTable(GridView1.Columns.Count);
            table.RunDirection = PdfWriter.RUN_DIRECTION_LTR;
            BaseFont bf = BaseFont.CreateFont("c:\\\\windows\\\\fonts\\\\tahoma.ttf", BaseFont.IDENTITY_H, true);
            iTextSharp.text.Font f2 = new iTextSharp.text.Font(bf, 8, iTextSharp.text.Font.NORMAL);
            
            //Transfer rows from GridView to table
            for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
            {
                if (GridView1.Rows[i].RowType == DataControlRowType.DataRow)
                {
                    for (int j = 0; j <= GridView1.Columns.Count - 1; j++)
                    {
                        string cellText = Page.Server.HtmlDecode(GridView1.Rows[i].Cells[j].Text);
                        iTextSharp.text.pdf.PdfPCell cell = new iTextSharp.text.pdf.PdfPCell(new Phrase(100, cellText, f2));
                        
                        
                        table.AddCell(cell);
                    }
                }
            }
            //Create the PDF Document
            Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
            PdfWriter.GetInstance(pdfDoc, Page.Response.OutputStream);
            pdfDoc.Open();
            Chunk c = new Chunk("Export GridView to PDF \n", FontFactory.GetFont("Verdana", 15));
            Paragraph p = new Paragraph();
            p.Alignment = Element.ALIGN_CENTER;
            p.Add(c);
            pdfDoc.Add(p); // add title            
            pdfDoc.Add(table); // add the table
            pdfDoc.Close();
            Page.Response.ContentType = "application/pdf";
            Page.Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.pdf");
            Page.Response.Cache.SetCacheability(HttpCacheability.NoCache);
            Page.Response.Write(pdfDoc);
            Page.Response.End();
        }
        catch (Exception ex)
        {
            Page.Response.Write(ex.Message);
        }

please help me solving this problem
ASKER CERTIFIED SOLUTION
AZZA-KHAMEES

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros