Remove time in itextsharp pdf document

Question

08.04.2018 12:44:21 datetime now

08.04.2018 I need..

//Adding DataRow
foreach (DataGridViewRow row in mp_faktura_listaDataGridView.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
PdfPCell cell2 = new PdfPCell(new Phrase(cell.Value.ToString(), calibri));
pdfTable.AddCell(cell2);
}
}

I try this

//Adding DataRow
foreach (DataGridViewRow row in mp_faktura_listaDataGridView.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
string dateVal = cell.Value.ToString().Split(',')[0];
PdfPCell cell2 = new PdfPCell(new Phrase(dateVal, calibri));
}
}

But dont work

Amit Gupta · Answer

foreach (DataGridViewCell cell in row.Cells) { if (cell.ColnIndex ==2) // change 2 wiyh your datetime column { string dateVal = Convwet.ToDateTime(cell.Value).ToString( "dd-MM-yyyy" ); PdfPCell cell2 = new PdfPCell( new Phrase(dateVal, calibri)); } } else PdfPCell cell2 = new PdfPCell( new Phrase(cell.Value, calibri)); } } Just you need to verify your datetime column before converting

Amit Gupta · Answer

foreach (DataGridViewCell cell in row.Cells) { string dateVal = Convwet.ToDateTime(cell.Value).ToString("dd-MM-yyyy"); PdfPCell cell2 = new PdfPCell(new Phrase(dateVal, calibri)); } }

Amit Gupta · Answer

Look at the line no 36. You haven't​ applied the code that I had posted. Please apply the code before asking that something is not working

Goran Bibic · Answer

Complete code for pdf click private void button9_Click(object sender, EventArgs e) { //Creating iTextSharp Table from the DataTable data //Console.WriteLine(drzaveDataGridView.ColumnCount); test za itext sharp PdfPTable pdfTable = new PdfPTable(mp_faktura_listaDataGridView.ColumnCount); pdfTable.DefaultCell.Padding = 3; pdfTable.WidthPercentage = 100; pdfTable.HorizontalAlignment = Element.ALIGN_LEFT; pdfTable.DefaultCell.BorderWidth = 1; pdfTable.DefaultCell.BorderWidth = 1; float [] sirina = new float [] { 0f, 15f, 40f, 70f, 25f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f }; pdfTable.SetWidths(sirina); BaseFont bfCalibri = BaseFont.CreateFont( "c:\windows\fonts\calibri.ttf" , BaseFont.IDENTITY_H, BaseFont.EMBEDDED); iTextSharp.text.Font calibri = new iTextSharp.text.Font(bfCalibri, 9); iTextSharp.text.Font calibri10bold3 = new iTextSharp.text.Font(bfCalibri, 9, iTextSharp.text.Font.BOLD, iTextSharp.text.BaseColor.WHITE); //Adding Header row foreach (DataGridViewColumn column in mp_faktura_listaDataGridView.Columns) { PdfPCell cell = new PdfPCell( new Phrase(column.HeaderText, calibri10bold3)); cell.BackgroundColor = new iTextSharp.text.BaseColor(243, 70, 5); pdfTable.AddCell(cell); } //Adding DataRow foreach (DataGridViewRow row in mp_faktura_listaDataGridView.Rows) { foreach (DataGridViewCell cell in row.Cells) { PdfPCell cell2 = new PdfPCell( new Phrase(cell.Value.ToString(), calibri)); pdfTable.AddCell(cell2); } } string folderPath = "C:\PDFs\" ; if (!Directory.Exists(folderPath)) { Directory.CreateDirectory(folderPath); } using (FileStream stream = new FileStream(folderPath + "Lista MP faktura.pdf" , FileMode.Create)) { iTextSharp.text.Font calibriTitle = new iTextSharp.text.Font(bfCalibri, 14, iTextSharp.text.Font.BOLD); iTextSharp.text.Font calibriSubTitle = new iTextSharp.text.Font(bfCalibri, 12); iTextSharp.text.Font calibriSubTitlebold = new iTextSharp.text.Font(bfCalibri, 14, iTextSharp.text.Font.BOLD); iTextSharp.text.Font calibri10bold = new iTextSharp.text.Font(bfCalibri, 10, iTextSharp.text.Font.BOLD); iTextSharp.text.Font calibri22bold = new iTextSharp.text.Font(bfCalibri, 22, iTextSharp.text.Font.BOLDITALIC); iTextSharp.text.Font calibrinaslov = new iTextSharp.text.Font(bfCalibri, 16); iTextSharp.text.Font calibriukupno = new iTextSharp.text.Font(bfCalibri, 12, iTextSharp.text.Font.BOLDITALIC); Document pdfDoc = new Document(PageSize.A4, 27f, 10f, 10f, 30f); // PdfWriter.GetInstance(pdfDoc, stream); PdfWriter writer = PdfWriter.GetInstance(pdfDoc, stream); pdfDoc.Open(); pdfDoc.Add( new ListItem(korisnik_programa, calibriTitle)); pdfDoc.Add( new ListItem(adresa, calibriSubTitle)); pdfDoc.Add( new ListItem(mesto, calibriSubTitle)); pdfDoc.Add( new ListItem( "JIB:" + " " + jib2, calibriSubTitle)); pdfDoc.Add( new ListItem( "PIB:" + " " + pib2, calibriSubTitle)); pdfDoc.Add( new ListItem( "Žiro-racun:" + " " + ziro_racun2, calibriSubTitle)); pdfDoc.Add( new ListItem( "E-mail:" + " " + e_mail, calibriSubTitle)); pdfDoc.Add( new ListItem( " " )); // pdfDoc.Add(new ListItem(" ")); pdfDoc.Add( new ListItem( " Lista maloprodajnih faktura " , calibrinaslov)); pdfDoc.Add( new ListItem( " " )); // pdfDoc.Add(new ListItem(" ")); pdfDoc.Add( new ListItem( " " )); PdfContentByte cb = writer.DirectContent; PdfContentByte cb1 = writer.DirectContent; cb.SetColorStroke( new BaseColor(41, 128, 185)); // boja linija iTextSharp.text.Rectangle fakturisao = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 520f, 50f); iTextSharp.text.Rectangle primio = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 60f, 50f); iTextSharp.text.Rectangle otpremio = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 330f, 50f); iTextSharp.text.Rectangle ukupno_za_uplatu = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 462f, 590f); // iTextSharp.text.Rectangle slogan_korisnika2 = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 340f, 10f, pdfDoc.PageSize.Width - 20f, 10f); //cb.SetColorStroke(new CMYKColor(1f, 0f, 0f, 0f));// boja linija // cb.SetColorStroke(new BaseColor(41,128,185));// boja linija // cb.SetColorFill(new CMYKColor(0f, 0f, 1f, 0f)); cb1.SetLineWidth(2); cb1.RoundRectangle(20f, 691f, 560f, 140f, 10f); // zaglavlje rectangle cb1.Stroke(); cb.SetLineWidth(1); cb.MoveTo(20f, 681f); //linija gornja zaglavlje cb.LineTo(580f, 681f); cb.Stroke(); cb.SetLineWidth(1); cb.MoveTo(20f, 652f); // linija donja zaglavlje cb.LineTo(580f, 652f); cb.Stroke(); cb.SetLineWidth(0.5); cb.MoveTo(20f, 20f); // linija donja slogan firme cb.LineTo(585f, 20f); cb.Stroke(); pdfDoc.Add(pdfTable); Paragraph par = new Paragraph( new Chunk( new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 40.0F, BaseColor.BLACK, Element.ALIGN_RIGHT, 1))); pdfDoc.Add(par); double [] columnData = new double [mp_faktura_listaDataGridView.Rows.Count]; columnData = (from DataGridViewRow row in mp_faktura_listaDataGridView.Rows where row.Cells[ "iznos_sa_pdv" ].FormattedValue.ToString() != string.Empty select Convert.ToDouble(row.Cells[ "iznos_sa_pdv" ].FormattedValue)).ToArray(); label16.Text = columnData.Sum().ToString( "#,0.00" ); par = new Paragraph( "UKUPNO: " + label16.Text + " KM" , calibriukupno); par.Alignment = Element.ALIGN_RIGHT; pdfDoc.Add(par); cb.SetLineWidth(0.5); cb.MoveTo(20f, 20f); // linija donja slogan firme cb.LineTo(585f, 20f); cb.Stroke(); // cb.SetLineWidth(1.5); // cb.MoveTo(5f, 5f); //linija korisnik programa // cb.LineTo(5f, 820f); // cb.Stroke(); pdfDoc.Close(); stream.Close(); System.Diagnostics.Process.Start(folderPath + "Lista MP faktura.pdf" ); } } } } } }

Goran Bibic · Answer

No have solution?

Goran Bibic · Answer

Reslut is... in line 13 need ToString() and open pdf document Column are mixed and datetimevalue is same 15.04.2018. 00:00:00 No have changes

Goran Bibic · Answer

I try this...in line 13 .. Error 1: cannot convert from object to float Error 2: cannot convert from ItextSharp.text.Font to ITextSharp.text.Chunk foreach (DataGridViewRow row in mp_faktura_listaDataGridView.Rows) { foreach (DataGridViewCell cell in row.Cells) { if (cell.ColumnIndex == 2) // change 2 wiyh your datetime column { string dateVal = Convert.ToDateTime(cell.Value).ToString( "dd-MM-yyyy" ); PdfPCell cell2 = new PdfPCell( new Phrase(dateVal, calibri)); } else { PdfPCell cell2 = new PdfPCell( new Phrase(cell.Value, calibri)); pdfTable.AddCell(cell2); } }

Goran Bibic · Answer

Error is ,,Invalid cast Int32 to DateTime,, Have couple columns...not only one...

Goran Bibic · Answer

Amit my dear friend //Adding DataRow foreach (DataGridViewRow row in mp_faktura_listaDataGridView.Rows) { foreach (DataGridViewCell cell in row.Cells) { //PdfPCell cell2 = new PdfPCell(new Phrase(cell.Value.ToString(), calibri)); // pdfTable.AddCell(cell2); if (cell.ColumnIndex == 2) // change 2 wiyh your datetime column { string dateVal = Convert.ToDateTime(cell.Value).ToString( "dd-MM-yyyy" ); PdfPCell cell2 = new PdfPCell( new Phrase(dateVal, calibri)); } else { PdfPCell cell2 = new PdfPCell( new Phrase(cell.Value.ToString(), calibri)); } } }

Remove time in itextsharp pdf document

Answers (9)