Upload PDF to AxacroPDF from Mysql

Question

Goodnight everyone. Hope you can help me ... I made a C # software with a MySql database. In one of the tables I must save a PDF document in each record. Set that column as LONGBLOB. What I need to know is how to do so that when I choose an already saved record from the datagrid, the corresponding PDF is automatically loaded into the axacroPDF without having to download the file to the PC. I did a test but it throws me 2 errors and it doesn't work. I leave my code. MILLIONS OF THANKS !!! private void datagridpagos_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { Pagos Form_Pagos = new Pagos(); DataGridViewRow Volcado_Pagos = datagridpagos.Rows[e.RowIndex]; { foreach(Form frm1 in Application.OpenForms) if (frm1.Name == "Pagos" ) { Form_Pagos = (Pagos) frm1; Form_Pagos.txtboxproveedor.Text = datagridpagos.CurrentRow.Cells[1].Value.ToString(); Form_Pagos.txtfechapago.Text = datagridpagos.CurrentRow.Cells[2].Value.ToString(); Form_Pagos.txtmodalidad.Text = datagridpagos.CurrentRow.Cells[3].Value.ToString(); Form_Pagos.txtimportepagado.Text = datagridpagos.CurrentRow.Cells[4].Value.ToString(); Form_Pagos.VisorPDF.src = datagridpagos.CurrentRow.Cells[5].Value.ToString(); this .Close(); break ; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }

Farhan Ahmed · Answer

see below sample code to save pdf file in database. //Store the PDF document to database //Create a new PDF document PdfDocument doc = new PdfDocument(); //Add a new PDF page PdfPage page = doc.Pages.Add(); //Draw the string page.Graphics.DrawString( "Hello World!" , new PdfStandardFont(PdfFontFamily.Helvetica, 15, PdfFontStyle.Bold), PdfBrushes.Red, PointF.Empty); //Save the PDF document MemoryStream ms = new MemoryStream(); doc.Save(ms); //Close the document doc.Close( true ); string dbFile = "database.mdb" ; string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbFile; //Create a new OleDbConnection OleDbConnection connection = new OleDbConnection(connectionString); //Open connection.Open(); string commandText = "insert into Table1 (FileName, FileContent) values('helloworld', @PDFFile)" ; //Create an OleDbCommand OleDbCommand command = new OleDbCommand(commandText, connection); //Store the PDF stream to database command.Parameters.AddWithValue( "PDFFile" , ms.ToArray()); command.ExecuteNonQuery(); connection.Close(); MessageBox.Show( "PDF successfully save to DataBase" );

Fernando Calabro · Answer

How are you? Good night. First of all I want to thank you very much for your answer, really. Regarding your answer, it seems to me that it is not what I need. I'll tell you how that part of the software is. For example. A merchant every time he makes a payment to his suppliers, he must load in a form the name of the supplier to whom he paid, the date of payment, the method of payment (for example, electronic or by bank), the amount paid ( each of these data in a different textbox) and you also have to save the payment receipt in PDF format (each payment made would be a record). Then, what you should be able to do is if you want to consult about a payment made (already saved) would be to select it from a datagrid and that the textboxes are loaded automatically with the information and the AxacroPDF should show the PDF saved in the database. The textbox part works fine for me, but I have problems with the PDF (when opening the form where the datagrid is, it throws me an error (2 times in a row), after closing the error the datagrid opens, but when choosing a record, All the data is loaded except the PDF. (I did the test of saving the records without the PDF and the error disappears, so I am sure that the problem is in the process of loading the PDF) In the MySql database (I use Workbench) I set the column where the PDF would be stored as LONGBLOB. I hope I explained myself well, lol, because I'm not good with English either and I'm using a translator. Sorry for writing so much, and again THANKS MILLIONS !!! Hug...!!!

Upload PDF to AxacroPDF from Mysql

Answers (2)