Solved

Export Grid view to PDF with specific table width

Posted on 2013-12-04
4
1,343 Views
Last Modified: 2013-12-12
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);
        }

Open in new window


please help me solving this problem
0
Comment
Question by:AZZA-KHAMEES
  • 3
4 Comments
 
LVL 4

Expert Comment

by:ItWorked
Comment Utility
are you searching for ?

PdfPTable table = new PdfPTable(2);
//actual width of table in points
table.TotalWidth = 216f;
0
 

Author Comment

by:AZZA-KHAMEES
Comment Utility
thank you for the reply, i manage to change the width of the of the columns using this

int[] intTblWidth = { 10, 10, 25, 50,25,25,50,10,50,10 };
table.SetWidths(intTblWidth);

Open in new window


1- how can i export the same look and feel of the grid view to the PDF?

2- is it possible to export it as landscape document?

3- also how can i change the margin of the exported PDF?
0
 

Accepted Solution

by:
AZZA-KHAMEES earned 0 total points
Comment Utility
I manage to solve the problem using this link
Exporting GridView to PDF

thank you
0
 

Author Closing Comment

by:AZZA-KHAMEES
Comment Utility
found the best solution
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now