How to append rows data on grid view to header on end event page when

I work on itextcharp library to export grid view to pdf . I face issue header column display within data and it must

display above of data so my issue data rows display above header exactly .

I need to display header on top then details rows data consistence with header

I need header data display on every page header meaning column headers and

title of pdf and and logo with white boxes display on every page so how to solve this issue .

ON end page event of class pageeventhelper I add header data because i need display header on every page

What I try as below :

[WebMethod]
        public byte[] ExportGridViewToPdf(string[][] gridData, string[] columnNames)
        {
            try
            {

            
                Document document = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
                var ms = new MemoryStream();
                var writer = PdfWriter.GetInstance(document, ms);
                var tahomaFontFile = Path.Combine(
 Environment.GetFolderPath(Environment.SpecialFolder.Fonts),
 "Tahoma.ttf");
                var tahomaBaseFont = BaseFont.CreateFont(tahomaFontFile,
     BaseFont.IDENTITY_H,
     BaseFont.EMBEDDED);
                var tahomaFont = new Font(tahomaBaseFont, 8, Font.NORMAL);
                PageEventHelper pageEventHelper = new PageEventHelper(columnNames, tahomaFont, gridData);
                writer.PageEvent = pageEventHelper;
                document.Open();




                var table = new PdfPTable(columnNames.Length)
                {

                    RunDirection = PdfWriter.RUN_DIRECTION_RTL
                };
                table.WidthPercentage = 100;

            


         
                foreach (var row in gridData)
                {
                    var cells = new PdfPCell[columnNames.Length];
                    for (int i = 0; i < columnNames.Length; i++)
                    {
                        cells[i] = new PdfPCell(new Phrase(row[i], tahomaFont));
                        cells[i].FixedHeight = 25f;
                        table.AddCell(cells[i]); // Add each cell individually
                    }
                }
                Paragraph paragraph = new Paragraph();


                Chunk dateChunk = new Chunk("Print Date :" + DateTime.Now.ToString("dd-MM-yyyy"));
                paragraph.Add(dateChunk);


                paragraph.Add(new Chunk("                                                                         ")); // Adjust the spacing as needed


                Chunk ministryChunk = new Chunk("Ministry of Industry AND Trade");
                paragraph.Add(ministryChunk);


                paragraph.Alignment = Element.ALIGN_LEFT;



                PdfPCell dateCell = new PdfPCell(paragraph)
                {
                    Colspan = columnNames.Length, // Span across all columns
                    BackgroundColor = new BaseColor(System.Drawing.Color.LightGray),
                    HorizontalAlignment = Element.ALIGN_RIGHT,
                    FixedHeight = 30f // Set the desired height (adjust as needed)
                };


                table.AddCell(dateCell);

                document.Add(table);


                document.Close();
                writer.Close();
 
                return ms.ToArray();
            }
            catch (Exception ex)
            {
                
                throw new Exception("Error exporting GridView to PDF: " + ex.Message);
            }
        }
using iText.Kernel.Pdf;
using iTextSharp.text;
using iTextSharp.text.pdf;
using System;
using System.Collections.Generic;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Web;

namespace EREG.BusinessLayer
{
    public class PageEventHelper : PdfPageEventHelper
    {
        private int pageNumber = 0;
        private int totalPages = 0;
        PdfTemplate footerTemplate;
        BaseFont bf = null;
        PdfContentByte cb;
        private readonly string[] _columnNames;
        private readonly iTextSharp.text.Font _tahomaFont;
        private readonly string[][] _gridData;
        public PageEventHelper(string[] columnNames, iTextSharp.text.Font tahomaFont, string[][] gridData)
        {
            _columnNames = columnNames;
            _tahomaFont = tahomaFont;
            _gridData = gridData;
        }
        
        public override void OnOpenDocument(iTextSharp.text.pdf.PdfWriter writer, Document document)
        {
            try
            {
                bf = BaseFont.CreateFont(BaseFont.HELVETICA, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
                cb = writer.DirectContent;
                footerTemplate = cb.CreateTemplate(50, 50);
            }
            catch (DocumentException de)
            {
                //handle exception here
            }
            catch (System.IO.IOException ioe)
            {
                //handle exception here
            }
        }
        public override void OnStartPage(iTextSharp.text.pdf.PdfWriter writer, Document document)
        {
            base.OnStartPage(writer, document);
            pageNumber++;
        }
        public override void OnCloseDocument(iTextSharp.text.pdf.PdfWriter writer, Document document)
        {
            base.OnCloseDocument(writer, document);
            //totalPages = writer.PageNumber;
            footerTemplate.BeginText();
            footerTemplate.SetFontAndSize(bf, 12);
            footerTemplate.SetTextMatrix(0, 0);
            footerTemplate.ShowText((writer.PageNumber - 1).ToString());
            footerTemplate.EndText();

        }

        public override void OnEndPage(iTextSharp.text.pdf.PdfWriter writer, Document document)
        {
            base.OnEndPage(writer, document);

            // Create a new PdfContentByte instance
            PdfContentByte cb = writer.DirectContent;

            // Add page number at the bottom
            string pageNumberText = $"Page {writer.PageNumber} of ";
            float pageNumberWidth = bf.GetWidthPoint(pageNumberText, 12);
            float pageNumberX = (document.PageSize.Width - pageNumberWidth) / 2;
            float pageNumberY = document.BottomMargin;

            cb.BeginText();
            cb.SetFontAndSize(bf, 12);
            cb.SetTextMatrix(pageNumberX, pageNumberY);
            cb.ShowText(pageNumberText);
            cb.EndText();

            // Add the total pages placeholder
            cb.AddTemplate(footerTemplate, pageNumberX + pageNumberWidth, pageNumberY);

            // Create and add the header table
            PdfPTable headerTable = new PdfPTable(_columnNames.Length) { RunDirection = iTextSharp.text.pdf.PdfWriter.RUN_DIRECTION_RTL };

            string imagePath = System.IO.Path.Combine(AppContext.BaseDirectory, "assets", "images", "logo_kw.png");

            System.Drawing.Image logoImage = System.Drawing.Image.FromFile(imagePath);

            iTextSharp.text.Image itextImage = iTextSharp.text.Image.GetInstance(logoImage, BaseColor.LIGHT_GRAY);

            string imagePath2 = System.IO.Path.Combine(AppContext.BaseDirectory, "assets", "images", "favicon.png");

            System.Drawing.Image logoImage2 = System.Drawing.Image.FromFile(imagePath2);

            iTextSharp.text.Image itextImage2 = iTextSharp.text.Image.GetInstance(logoImage2, BaseColor.LIGHT_GRAY);

            //string imagePath3 = System.IO.Path.Combine(AppContext.BaseDirectory, "assets", "images", "logo-newkuwit.png");

            //System.Drawing.Image logoImage3 = System.Drawing.Image.FromFile(imagePath3);

            //iTextSharp.text.Image itextImage3 = iTextSharp.text.Image.GetInstance(logoImage3, BaseColor.LIGHT_GRAY);



            PdfPCell logoCell = new PdfPCell();
            logoCell.Colspan = _columnNames.Length; // Span across all columns
            logoCell.BackgroundColor = new BaseColor(System.Drawing.Color.SkyBlue);
            logoCell.HorizontalAlignment = Element.ALIGN_CENTER;
            logoCell.VerticalAlignment = Element.ALIGN_MIDDLE;
            logoCell.FixedHeight = 100f;





            PdfPTable imageTable = new PdfPTable(2);
            imageTable.WidthPercentage = 100;
            imageTable.DefaultCell.Border = iTextSharp.text.Rectangle.NO_BORDER;

            itextImage.ScaleToFit(logoCell.FixedHeight - 10, logoCell.FixedHeight - 30);
            imageTable.AddCell(new PdfPCell(itextImage) { Colspan = 1, Border = iTextSharp.text.Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER, VerticalAlignment = Element.ALIGN_MIDDLE });


            itextImage2.ScaleToFit(logoCell.FixedHeight - 10, logoCell.FixedHeight - 30);
            imageTable.AddCell(new PdfPCell(itextImage2) { Colspan = 1, Border = iTextSharp.text.Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT, VerticalAlignment = Element.ALIGN_MIDDLE });

            //itextImage3.ScaleToFit(logoCell.FixedHeight - 10, logoCell.FixedHeight - 30);
            //imageTable.AddCell(new PdfPCell(itextImage3) { Colspan = 1, Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT, VerticalAlignment = Element.ALIGN_MIDDLE });

            logoCell.AddElement(imageTable);
            headerTable.AddCell(logoCell);





            headerTable.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin;
            headerTable.LockedWidth = true;
            string titleText = "??????? ????? ???????? ?????? ????? ????? ????????";
            var titleCell = new PdfPCell(new Phrase(titleText, _tahomaFont))
            {
                Colspan = _columnNames.Length, // Span across all columns
                BackgroundColor = new BaseColor(System.Drawing.Color.LightGray),
                HorizontalAlignment = Element.ALIGN_CENTER,
                FixedHeight = 30f // Set the desired height (adjust as needed)
            };
            headerTable.AddCell(titleCell);
            foreach (var columnName in _columnNames)
            {
                var cell = new PdfPCell(new Phrase(columnName, _tahomaFont));
                cell.BackgroundColor = new BaseColor(System.Drawing.Color.LightGray);
                cell.HorizontalAlignment = Element.ALIGN_CENTER;
                headerTable.AddCell(cell);
            }

           
            headerTable.WriteSelectedRows(0, -1, document.LeftMargin, document.PageSize.Height - document.TopMargin - 20, cb);

          


           


          
        }
        
    }
}

image show issue as below

Ahmed, Revise your PageEventHelper Class:

using System;
using System.IO;
using iTextSharp.text;
using iTextSharp.text.pdf;

public class PageEventHelper : PdfPageEventHelper
{
    private PdfTemplate _totalPagesTemplate;
    private BaseFont _baseFont;
    private string[] _columnNames;
    private Font _headerFont;
    
    public PageEventHelper(string[] columnNames, Font headerFont)
    {
        _columnNames = columnNames;
        _headerFont = headerFont;
    }

    public override void OnOpenDocument(PdfWriter writer, Document document)
    {
        _baseFont = BaseFont.CreateFont(BaseFont.HELVETICA, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
        _totalPagesTemplate = writer.DirectContent.CreateTemplate(50, 50);
    }

    public override void OnEndPage(PdfWriter writer, Document document)
    {
        AddPageHeader(writer, document);
        AddPageFooter(writer, document);
    }

    private void AddPageHeader(PdfWriter writer, Document document)
    {
        PdfPTable headerTable = new PdfPTable(_columnNames.Length)
        {
            TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin,
            LockedWidth = true
        };

        foreach (string columnName in _columnNames)
        {
            PdfPCell headerCell = new PdfPCell(new Phrase(columnName, _headerFont))
            {
                HorizontalAlignment = Element.ALIGN_CENTER,
                BackgroundColor = BaseColor.LIGHT_GRAY
            };
            headerTable.AddCell(headerCell);
        }

        headerTable.WriteSelectedRows(0, -1, document.LeftMargin, document.PageSize.Height - document.TopMargin + headerTable.TotalHeight, writer.DirectContent);
    }

    private void AddPageFooter(PdfWriter writer, Document document)
    {
        string text = "Page " + writer.PageNumber + " of ";
        float textSize = _baseFont.GetWidthPoint(text, 12);
        float textBase = document.BottomMargin - 20;

        PdfContentByte cb = writer.DirectContent;
        cb.BeginText();
        cb.SetFontAndSize(_baseFont, 12);
        cb.SetTextMatrix((document.PageSize.Width - textSize) / 2, textBase);
        cb.ShowText(text);
        cb.EndText();
        cb.AddTemplate(_totalPagesTemplate, (document.PageSize.Width - textSize) / 2 + textSize, textBase);
    }

    public override void OnCloseDocument(PdfWriter writer, Document document)
    {
        _totalPagesTemplate.BeginText();
        _totalPagesTemplate.SetFontAndSize(_baseFont, 12);
        _totalPagesTemplate.SetTextMatrix(0, 0);
        _totalPagesTemplate.ShowText("" + (writer.PageNumber - 1));
        _totalPagesTemplate.EndText();
    }
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tuhin Paul2y ago

In your main ExportGridViewToPdf method, check the table data starts below the header. This can be achieved by verifying you don’t add the header and footer data directly into the table, but rather manage them via the PageEventHelper.

[WebMethod]
public byte[] ExportGridViewToPdf(string[][] gridData, string[] columnNames)
{
    try
    {
        Document document = new Document(PageSize.A4, 10f, 10f, 50f, 50f); // Adjust margins as needed
        var ms = new MemoryStream();
        var writer = PdfWriter.GetInstance(document, ms);
        var tahomaFontFile = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Fonts), "Tahoma.ttf");
        var tahomaBaseFont = BaseFont.CreateFont(tahomaFontFile, BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
        var tahomaFont = new Font(tahomaBaseFont, 8, Font.NORMAL);

        PageEventHelper pageEventHelper = new PageEventHelper(columnNames, tahomaFont, gridData);
        writer.PageEvent = pageEventHelper;

        document.Open();

        var table = new PdfPTable(columnNames.Length)
        {
            RunDirection = PdfWriter.RUN_DIRECTION_RTL,
            WidthPercentage = 100
        };

        foreach (var row in gridData)
        {
            for (int i = 0; i < columnNames.Length; i++)
            {
                table.AddCell(new PdfPCell(new Phrase(row[i], tahomaFont))
                {
                    FixedHeight = 25f
                });
            }
        }

        document.Add(table);

        document.Close();
        writer.Close();

        return ms.ToArray();
    }
    catch (Exception ex)
    {
        throw new Exception("Error exporting GridView to PDF: " + ex.Message);
    }
}

Nikunj Satasiya2y ago