Remove time in itextsharp pdf document for multiple colum c#

Goran Bibic

Date time remove time from pdf report need date an payment to be 01.01.2019 without time

if (c == 2) my report is

date payment
01.01.2019 01.01.2019 00:00:00

I try to add this

if (c == 2) && (c == 3) my report is

         date payment
01.01.2019 00:00:00    01.01.2019 00:00:00

I try to add d (like on example code) if (c == 2) && (d == 3)
my report is

           date payment

01.01.2019 00:00:00 01.01.2019 00:00:00

Some help?

//Adding DataRow
foreach (DataGridViewRow row in AnalitickaKarticaPartneraDataGridView.Rows)
{
int c = 0;
int d = 0;
foreach (DataGridViewCell cell in row.Cells)
{
if (c == 2 && d == 3)
{
PdfPCell cell2 = new PdfPCell(new Phrase(cell.Value.ToString().Split(' ')[0], calibri));
pdfTable.AddCell(cell2);
}
else
{
PdfPCell cell2 = new PdfPCell(new Phrase(cell.Value.ToString(), calibri));
pdfTable.AddCell(cell2);
}
c++;
d++;
}
}

7 Replies

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

Goran Bibic7y ago
Ok. Implement?
Amit Mohanty7y ago
Then check the cell value is a DateTime value or not or use DateTime.TryParseExact.
Goran Bibic7y ago
I HAVE MULTIPLE COLUMN IN TABLE...JUST 2 COLUMN ARE DATITIME
Goran Bibic7y ago
Error is

System.FormatException: String was not recognized as a valid DateTime.
Amit Mohanty7y ago
Replace your code with below code.
foreach (DataGridViewRow row in AnalitickaKarticaPartneraDataGridView.Rows)
{
    int c = 0;
    int d = 0;
    foreach (DataGridViewCell cell in row.Cells)
    {
        if (c == 2 && d == 3)
        {
            PdfPCell cell2 = new PdfPCell(new Phrase(DateTime.Parse(cell.Value.ToString()).ToString("dd.MM.YYYY").Split(' ')[0], calibri));
            pdfTable.AddCell(cell2);
        }
        else
        {
            PdfPCell cell2 = new PdfPCell(new Phrase(DateTime.Parse(cell.Value.ToString()).ToString("dd.MM.YYYY"), calibri));
            pdfTable.AddCell(cell2);
        }
        c++;
        d++;
    }
}
Goran Bibic7y ago
How to implement in my solution?
DateTime.Parse(cell.Value.ToString()).ToString("dd.MM.YYYY")
In whitch line?
Amit Mohanty7y ago
Hey convert the cell value like below code.
DateTime.Parse(cell.Value.ToString()).ToString("dd.MM.YYYY")