Read PDF file from sql to AxAcroPDF c#

Goran Bibic

8y4.9kLearn iOS Programming

Some help?

I try this but dont work, no have errors but not read file...please help

{
if (documentsDataGridView.SelectedRows.Count > 0)
{
string id = documentsDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn1"].Value.ToString();
string number = documentsDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn2"].Value.ToString();
string count_number = documentsDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn3"].Value.ToString();
string label = documentsDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn4"].Value.ToString();
string partner = documentsDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn5"].Value.ToString();
string tax_number = documentsDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn6"].Value.ToString();
string file_location = documentsDataGridView.SelectedRows[0].Cells["file_location"].Value.ToString();
//string pdf_file = documentsDataGridView.SelectedRows[0].Cells["pdf_file"].Value.ToString();
idTextBox.Text = id;
numberTextBox.Text = number;
count_numberTextBox.Text = count_number;
labelTextBox.Text = label;
partnerComboBox.Text = partner;
tax_numberTextBox.Text = tax_number;
dateDateTimePicker.Value = Convert.ToDateTime(documentsDataGridView.SelectedRows[0].Cells["dataGridViewTextBoxColumn7"].Value);
file_locationTextBox.Text = file_location;
//axAcroPDF1.src = pdf_file;
try
{
if (documentsDataGridView.SelectedRows[0].Cells["pdf_file"].Value != null)
{
byte[] ap = (byte[])(documentsDataGridView.SelectedRows[0].Cells["pdf_file"].Value);
MemoryStream ms = new MemoryStream(ap);
axAcroPDF1.src = LocalEncoding.GetString(ms.ToArray());
//axAcroPDF1.LoadFile(ms);
}
else
{
axAcroPDF1.src = null;
}
}
catch
{
axAcroPDF1.src = null;
}
}
}

5 Replies

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

Fernando Calabro6y ago
How are you? I have the same problem ... I swear I don't know how many days I have been with this issue and I can't find the solution. I get exactly the same error, and it loads me all the data except the axacrobatPDF (that is ... when I want to save the file yes, I choose it, load it and save it in the base as longblob, but when I want to see it it throws me that error (2 times) .and if I click on the axacrobat it appears to me as if it started to load but it doesn't really load and it remains there ... Could you solve it? YOU DON'T KNOW HOW YOU SAVE ME IF YOU COULD FIX IT !!!THANK YOU !!!
Goran Bibic8y ago
I have error now
Goran Bibic8y ago
I try this but dont work
byte[] ap = (byte[])(documentsDataGridView.SelectedRows[0].Cells["pdf_file"].Value);
MemoryStream ms = new MemoryStream(ap);
ms.Position = 0;
File.WriteAllBytes(@"D:\mypdf.pdf", ms.ToArray());
Process.Start(@"D:\mypdf.pdf");
Goran Bibic8y ago
No have error. From line 27-36 app need to read pdf file from app

I insert pdf in database nad just need to retrive him in axAcroPDF1
try
               {
                   if (documentsDataGridView.SelectedRows[0].Cells["pdf_file"].Value != null)

                   {
                       byte[] ap = (byte[])(documentsDataGridView.SelectedRows[0].Cells["pdf_file"].Value);
                       MemoryStream ms = new MemoryStream(ap);
                       axAcroPDF1.src = LocalEncoding.GetString(ms.ToArray());
                       //axAcroPDF1.LoadFile(ms);


                   }
                   else
                   {
                       axAcroPDF1.src = null;
                   }
               }
               catch
               {
                   axAcroPDF1.src = null;
               }
Nitin Sontakke8y ago
Always, post error message as well. Without which it is difficult to guess what is happening.