Read PDF doc to axAcroPDF c#

Question

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

Goran Bibic · Answer

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

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

Goran Bibic · Answer

Maybe some solution with data reader?

Goran Bibic · Answer

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?