Read PDF file from sql to AxAcroPDF c#

Question

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

Nitin Sontakke · Answer

Always, post error message as well. Without which it is difficult to guess what is happening.

Fernando Calabro · Answer

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 Bibic · Answer

I have error now

Goran Bibic · Answer

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 Bibic · Answer

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