Convert datagridview data with Image from SQL Db into a PDF

Question

hello everyone, greetings to all !!!

Im Newbie to creating C# Desktop App..
Can anyone help me out that- how can i export/ convert my datagridview data with image column which is filtered from my SQL Db into a PDF file in C#?
#Note: Its a Desktop App

Amit Mohanty · Answer

Hey check the below link https://www.c-sharpcorner.com/blogs/export-datagridview-data-to-pdf-in-c-sharp To change an image to pdf you have to make some changes in code. Change foreach (DataGridViewRow row in dataGridView1.Rows) { foreach (DataGridViewCell cell in row.Cells) { pdfTable.AddCell(cell.Value.ToString()); } } //Change the above code with below code foreach (DataGridViewRow row in dataGridView1.Rows) { string id = row.Cells[0].Value.ToString(); pdfTable.AddCell(id); string name = row.Cells[1].Value.ToString(); pdfTable.AddCell(name); string city = row.Cells[2].Value.ToString(); pdfTable.AddCell(city); string department = row.Cells[3].Value.ToString(); pdfTable.AddCell(department); string gender = row.Cells[4].Value.ToString(); pdfTable.AddCell(gender); string email = row.Cells[5].Value.ToString(); pdfTable.AddCell(email); // Now your image cell byte [] imageByte = ( byte [])row.Cells[6].Value; iTextSharp.text.Image myImage = iTextSharp.text.Image.GetInstance(imageByte); pdfTable.AddCell(myImage); }

Kareem Said · Answer

You can use Spire.PDF to export data and image from database to pdf. using System; using System.Data; using System.Data.OleDb; using System.Drawing; using System.Windows.Forms; using Spire.Pdf; using Spire.Pdf.Graphics; using Spire.Pdf.Tables; namespace DataSource { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click( object sender, EventArgs e) { //Create a pdf document PdfDocument doc = new PdfDocument(); //Set the margin PdfUnitConvertor unitCvtr = new PdfUnitConvertor(); PdfMargins margin = new PdfMargins(); margin.Top = unitCvtr.ConvertUnits(2.54f, PdfGraphicsUnit.Centimeter, PdfGraphicsUnit.Point); margin.Bottom = margin.Top; margin.Left = unitCvtr.ConvertUnits(3.17f, PdfGraphicsUnit.Centimeter, PdfGraphicsUnit.Point); margin.Right = margin.Left; //Create one page PdfPageBase page = doc.Pages.Add(PdfPageSize.A4, margin); float y = 10; //Title PdfBrush brush1 = PdfBrushes.Black; PdfTrueTypeFont font1 = new PdfTrueTypeFont( new Font( "Arial" , 16f, FontStyle.Bold)); PdfStringFormat format1 = new PdfStringFormat(PdfTextAlignment.Center); page.Canvas.DrawString( "Country List" , font1, brush1, page.Canvas.ClientSize.Width / 2, y, format1); y = y + font1.MeasureString( "Country List" , format1).Height; y = y + 5; //Create data table PdfTable table = new PdfTable(); table.Style.CellPadding = 2; table.Style.BorderPen = new PdfPen(brush1, 0.75f); table.Style.DefaultStyle.BackgroundBrush = PdfBrushes.SkyBlue; table.Style.DefaultStyle.Font = new PdfTrueTypeFont( new Font( "Arial" , 10f)); table.Style.AlternateStyle = new PdfCellStyle(); table.Style.AlternateStyle.BackgroundBrush = PdfBrushes.LightYellow; table.Style.AlternateStyle.Font = new PdfTrueTypeFont( new Font( "Arial" , 10f)); table.Style.HeaderSource = PdfHeaderSource.ColumnCaptions; table.Style.HeaderStyle.BackgroundBrush = PdfBrushes.CadetBlue; table.Style.HeaderStyle.Font = new PdfTrueTypeFont( new Font( "Arial" , 11f, FontStyle.Bold)); table.Style.HeaderStyle.StringFormat = new PdfStringFormat(PdfTextAlignment.Center); table.Style.ShowHeader = true ; using (OleDbConnection conn = new OleDbConnection()) { conn.ConnectionString = @ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\..\..\Data\demo.mdb" ; OleDbCommand command = new OleDbCommand(); command.CommandText = " select Name,Capital,Continent,Area,Population from country " ; command.Connection = conn; using (OleDbDataAdapter dataAdapter = new OleDbDataAdapter(command)) { DataTable dataTable = new DataTable(); dataAdapter.Fill(dataTable); table.DataSourceType = PdfTableDataSourceType.TableDirect; table.DataSource = dataTable; } } float width = page.Canvas.ClientSize.Width - (table.Columns.Count + 1) * table.Style.BorderPen.Width; table.Columns[0].Width = width * 0.24f * width; table.Columns[0].StringFormat = new PdfStringFormat(PdfTextAlignment.Left, PdfVerticalAlignment.Middle); table.Columns[1].Width = width * 0.21f * width; table.Columns[1].StringFormat = new PdfStringFormat(PdfTextAlignment.Left, PdfVerticalAlignment.Middle); table.Columns[2].Width = width * 0.24f * width; table.Columns[2].StringFormat = new PdfStringFormat(PdfTextAlignment.Left, PdfVerticalAlignment.Middle); table.Columns[3].Width = width * 0.13f * width; table.Columns[3].StringFormat = new PdfStringFormat(PdfTextAlignment.Right, PdfVerticalAlignment.Middle); table.Columns[4].Width = width * 0.18f * width; table.Columns[4].StringFormat = new PdfStringFormat(PdfTextAlignment.Right, PdfVerticalAlignment.Middle); PdfLayoutResult result = table.Draw(page, new PointF(0, y)); y = y + result.Bounds.Height + 5; PdfBrush brush2 = PdfBrushes.Gray; PdfTrueTypeFont font2 = new PdfTrueTypeFont( new Font( "Arial" , 9f)); page.Canvas.DrawString(String.Format( "* {0} countries in the list." , table.Rows.Count), font2, brush2, 5, y); //Save the document doc.SaveToFile( "DataSource.pdf" ); doc.Close(); } } }

Sumonto Mehedi · Answer

Amit Mohanty, thanks for replying!! im stucked..your coding approach got me error saying- Unable to cast object of type 'System.Drawing.Bitmap' to type 'System.Byte[]' its unable to cast datagridview bitmap image to byte[], what should i do now?