Read PDF doc to axacropdf from MS sqlc#

Question

1.00/5 (1 vote)

See more:

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?

What I have tried:

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;  //here is error
  
  
                          
                    }  
                    else {  
                        axAcroPDF1.src = null;  
                    }  
                }  
                catch  
                {  
                    axAcroPDF1.src = null;  
                }

Posted 18-Jul-18 9:38am

Goran Bibic

Updated 19-Jul-18 4:33am

Add a Solution

Comments

Patrice T 18-Jul-18 17:53pm

What are you trying to do?
What you don't understand in the error message ?

Goran Bibic 19-Jul-18 1:41am

I want to read file from database

datagrid selection changed

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

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2018-07-19T04:33:00

Solution 2

As Gerry said, the control you're using doesn't support loading files from a stream. You have to save them to disk first.

C#

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;

NB: You'll need some code to delete the temporary file when you've finished with it, or when your application closes.

If you want a control that supports loading directly from the stream, try PdfiumViewer[^], which uses Google's Pdfium library[^]. If you install it via NuGet, pay attention to the installation instructions[^] - you'll need one or more additional packages to install the native Pdfium library.

Posted 19-Jul-18 4:33am

Richard Deeming

Comments

Goran Bibic 20-Jul-18 2:35am

I have location of file every time when upload pdf. like

D:\SPEDICIJA MERIDIJAN\informacija\SKM2556.pdf

This is in sql database inserted when upload file.

Maybe to use that?

Instead this string tempName = Path.Combine(Path.GetTempPath(), Path.GetRandomFileName() + ".pdf");

Column name in sql is file_location

Richard Deeming 20-Jul-18 7:20am

If that file location is valid on every computer where your application is running, then that would work.

Typically, you would use a UNC path pointing to a shared folder on a server on the local network for that. Or a path pointing to a mapped network drive that's mapped by all computers running your code.

Goran Bibic 20-Jul-18 2:38am

Error is when open my app
File is not started with '%PDF-'
file:///C|/Users/PC/AppData/Local/Temp/ozcbqyu.zmu.pdf

Richard Deeming 20-Jul-18 7:21am

That error suggests that the data in your database is not a valid PDF file.

Goran Bibic 23-Jul-18 1:31am

I use this code for insert pdf file...

byte[] filedata = null;
MemoryStream ms = new MemoryStream();
filedata = ms.GetBuffer();
axAcroPDF1.src = LocalEncoding.GetString(ms.ToArray());

insert into dbo.documents (pdf_file) VALUES (@pdf_files)
querySaveStaff.Parameters.AddWithValue("@pdf_file",SqlDbType.Binary).Value=filedata;

Is this way ok?

Richard Deeming 23-Jul-18 7:40am

No.

Look at your code again. At which point do you think you're loading the bytes from an existing PDF and sending them to SQL?

You're not. You're creating an empty MemoryStream; getting the MemoryStream's buffer, which at this point is an empty byte array; converting that to a string, which will be empty, and telling the AcroPDF control to load it; and passing that empty byte array to SQL.

If you want to insert the content of a PDF file into SQL, then you need to read the content of that PDF file!

Goran Bibic 20-Jul-18 4:08am

Maybe some solution with data reader?

Gerry Schmitz · Answer 2 · 2018-07-18T14:45:00

Solution 1

It's (probably) asking for the "path to a PDF file" (and not a "stream");

Copy the stream to a disk file, and supply the "file path" string (where you got your error).

Posted 18-Jul-18 14:45pm

Gerry Schmitz

Comments

Goran Bibic 19-Jul-18 1:40am

But I dont have path location....I just want to read file from database

Simon_Whale 19-Jul-18 5:49am

what you need to do is read the blob from the database and save it temporarily to file on the local machine and then load the pdf in the normal way.

Goran Bibic 19-Jul-18 8:28am

To find from some location? Folder some exmpl...? Just way from database? I think it is ok solution to insert in database like varbinary(MAX).

That is bad solution?

Goran Bibic 20-Jul-18 4:08am

Maybe some solution with data reader?