Upload PDF to AxacroPDF from Mysql

Fernando Calabro

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);
}
}

2 Replies

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

Fernando Calabro6y ago
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...!!!
0
Farhan Ahmed6y ago
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");
+1