avoid duplicate value datagridview to iTextSharp

Shovan Saha

9y1kLearn iOS Programming

I do not want to see duplicate value in pdf report from datagridview, how?

foreach (DataRow r in dt.Rows)

{

if (dt.Rows.Count > 0)

{

pdfTable.AddCell(new Phrase(r[2].ToString(), fontTable2));

pdfTable.AddCell(new Phrase(r[3].ToString(), fontTable2));

pdfTable.AddCell(new Phrase(r[4].ToString(), fontTable2));

}

4 Replies

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

Pusting9y ago
Accepted answer
That seems like an overly complicated solution, I would suggest you to instead take a look at the following example:

https://www.gemboxsoftware.com/spreadsheet/examples/c-sharp-vb-net-import-export-excel-datagridview/5301

In short, the example demonstrates how to export DataGridView directly to an ExcelWorksheet object by using GemBox.Spreadsheet library.
After that you can search for duplicate values in ExcelWorksheet.Rows and delete ones that you don't need.

Alternativally, you could export the DataGridView to a DataTable and then do the needed deletion on it and then export that DataTable directly to ExcelWorksheet object, again by using GemBox.Spreadsheet:

https://www.gemboxsoftware.com/spreadsheet/examples/c-sharp-export-datatable-to-excel/501

Last, you just need to save ExcelFile object to PDF, without having to use HTML as an intermediate.
Also as an FYI, the difference between exporting DataGridView directly or exporting DataGridView's DataTable is that in the first approach you'll also get the style and formatting that is used in DataGridView in your resulting PDF file.
0
Sameer Shaik9y ago
I can't give you complete code for this, but i can guide you through steps to achieve this with sample references.

1) you need to perform groupby and sum on your datatable and generate datatable as you want for report,
https://stackoverflow.com/questions/27378537/convert-datatable-groupby-multiple-columns-with-sum-using-linq

2) Convert DataTable to HTML String and store in String Variable
http://www.c-sharpcorner.com/UploadFile/deveshomar/export-datatable-to-html-in-C-Sharp/

3) Generate Pdf from the Html string and Save pdf report.
https://www.aspsnippets.com/Articles/Export-HTML-string-to-PDF-file-using-iTextSharp-in-ASPNet.aspx

Just take the required methods from the sample references and implement in your C# desktop.
0

Shovan Saha9y ago

Dear Sammer Sir, please write a single code for me or provide me a link that I can understand.

C#, desktop application

I have a datagridview like this:

ID	Date	SoinikNo	APenName	Pension	Utsob
9	01/01/2017	L	A	3	2
16	05/02/2017	M	B	4	3
29	12/03/2017	L	A	5	7
33	17/04/2017	M	B	6	8
47	25/05/2017	L	A	3	5
52	13/06/2017	S	C	2	9
82	02/07/2017	S	C	1	12

I need a new datagridview / iTextsharp report like this:

Sl. No.	SoinikNo	APenName	Pension	Utsob
1	L	A	11	14
2	M	B	10	11
3	S	C	3	21

Sameer Shaik9y ago
what are you trying to do? your question is not clear !
and your sample code also need some changes
you dont need if (dt.Rows.Count > 0) inside foreach loop
0