Export data in pdf in window application

Jitendra Sharma

9y955Learn iOS Programming

Sir

i am sharing export datagridview to pdf code and datagridview structure also

now i want last two column not print like edit or print only convert required column

that how to do

all colum 8 but two is edit or print so i dont want print or export last two print or edit please

if (result == DialogResult.Yes)

{

SaveFileDialog savefile = new SaveFileDialog();

// set a default file name

savefile.FileName = "PO.pdf";

// set filters - this can be done in properties as well

savefile.Filter = "Text files (*.pdf)|*.pdf|All files (*.*)|*.*";

if (savefile.ShowDialog() == DialogResult.OK)

{

//Creating iTextSharp Table from the DataTable data

PdfPTable pdfTable = new PdfPTable(dtgrdvwsalepo.ColumnCount);

pdfTable.DefaultCell.Padding = 4;

pdfTable.WidthPercentage = 100;

pdfTable.HorizontalAlignment = Element.ALIGN_MIDDLE;

pdfTable.DefaultCell.BorderWidth = 1;

// Adding Header row

foreach (DataGridViewColumn column in dtgrdvwsalepo.Columns)

{

PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText));

cell.BackgroundColor = new iTextSharp.text.Color(240, 240, 240);

pdfTable.AddCell(cell);

}

//Adding DataRow

foreach (DataGridViewRow row in dtgrdvwsalepo.Rows)

{

foreach (DataGridViewCell cell in row.Cells)

{

pdfTable.AddCell(cell.Value.ToString());

}

//Exporting to PDF

using (FileStream stream = new FileStream(savefile.FileName, FileMode.Create))

{

Document pdfDoc = new Document(PageSize.A2, 10f, 10f, 10f, 0f);

PdfWriter.GetInstance(pdfDoc, stream);

pdfDoc.Open();

pdfDoc.Add(pdfTable);

pdfDoc.Close();

stream.Close();

}

MessageBox.Show("Your pdf generated successfully!");

}

3 Replies

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

Amit Gupta9y ago
Hey Jitendra,
Make some changes as below:
1.
DataTable data
PdfPTable pdfTable = new PdfPTable(dtgrdvwsalepo.ColumnCount -2 );
2. Replacing foreach with for loop
// Adding Header row
//foreach (DataGridViewColumn column in dtgrdvwsalepo.Columns)
for (int x =0; x < dtgrdvwsalepo.Columns.Count-2; x++)
{
DataGridViewColumn column = dtgrdvwsalepo.Columns[x];
PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText));
3. One more change
//Adding DataRow
foreach (DataGridViewRow row in dtgrdvwsalepo.Rows)
{
//foreach (DataGridViewCell cell in row.Cells)
for (int i =0; i < row.Cells.Count-2; i++)
{
DataGridViewCell cell = row.Cells [i];
pdfTable.AddCell(cell.Value.ToString());
}
I think thats all you have to do.

Apart from this, I prefer to use ReportViewer, just need to design once and can be exported to pdf, xls and more but till I am unaware of your requirement, you can use as per your need.
Jitendra Sharma9y ago
but how to used .. will u explain with code....
Amit Gupta9y ago
You can use for loop instead of foreach by just putting columns.count-2 as its condition. Thats it