Read PDF doc to axAcroPDF c#

Goran Bibic

8y8.9kLearn iOS Programming

I need to read from ms sql file to adobe PDF reader

Error is line 8

Error CS0029 Cannot implicitly convert type 'System.IO.MemoryStream' to 'string'

Some help?

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 = ms;
}
else {
axAcroPDF1.src = null;
}
}
catch
{
axAcroPDF1.src = null;
}

4 Replies

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

Goran Bibic8y ago
Maybe some solution with data reader?
Goran Bibic8y ago
I find some solution
byte[] ap = (byte[])documentsDataGridView.SelectedRows[0].Cells["pdf_file"].Value;
string tempName = Path.Combine(Path.GetTempPath(), Path.GetRandomFileName() + ".pdf");
File.WriteAllBytes(tempName, ap);
axAcroPDF1.src = tempName;
But have some error when open form in my app
File is not started with '%PDF-'
file:///C|/Users/PC/AppData/Local/Temp/ozcbqyu.zmu.pdf
Some help?
Goran Bibic8y ago
Add this
private static readonly Encoding LocalEncoding = Encoding.UTF8;
and try this. No errors but not read from sql
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);
                        //dataPictureBox.Image = System.Drawing.Image.FromStream(ms);

                        axAcroPDF1.src = LocalEncoding.GetString(ms.ToArray());
                    }
                    else {
                        axAcroPDF1.src = null;
                    }
                }
                catch
                {
                    axAcroPDF1.src = null;
                }
Jenith Thakkar8y ago
replace axAcroPDF1.src =ms; to
axAcroPDF1.src = LocalEncoding.GetString(ms.ToArray());

For LocalEncoding you need to define this before start your method
'private static readonly Encoding LocalEncoding = Encoding.UTF8;'

Please check this Link
https://stackoverflow.com/questions/10446194/reading-from-memory-stream-to-string