How can I redisplay a stored PDF from SQL database in adobe reader tool ؟

Question

0.00/5 (No votes)

See more:

hi friends
I have a vb.net project to store PDF files in a sql server database
when I choose the file from device it displayed in adobe reader tool in the form,
once I click on save button the file is storing in DB as "

VarBinary

" and it's name displayed in the datagridview in the form.
I want to redisplay any pdf file when I double click on it's name in the datagridview

What I have tried:

this the code I use to store PDF files in DB:

Dim fs As New FileStream(ofd.FileName, FileMode.Open, FileAccess.Read)
Dim br As New BinaryReader(fs)
Dim Filepdf() As Byte = br.ReadBytes(br.BaseStream.Length)
cmd.Parameters.Add(New SqlParameter("@PDF_File", SqlDbType.VarBinary)).Value = Filepdf

Posted 8-Oct-20 6:27am

adnan gharbi

Add a Solution

Comments

Richard MacCutchan 8-Oct-20 12:45pm

You just need to reverse that process. Extract the VarBinary data from the database and save it to disk. You can then pass it to the tool to display it.

adnan gharbi 8-Oct-20 13:05pm

I don't want to save it to disk and pass it to the tool to display it
Imagine you have hundreds of pdf files and want to browse them one by one؟
Will I every time have to save the file in the device and then call it back to the tool ?? The process will be very stressful
I want to display it directly in the too

RedDk 8-Oct-20 13:22pm

Absolutely!

What RmC says. What do you think you're going to do? Everytime you want to read one .pdf, you scroll to some point in the entire downloaded .pdf database and read there?

adnan gharbi 8-Oct-20 13:44pm

I think I need some time to understand what you all said, or maybe I just couldn't get the idea right
To solve the problem:
Can someone write for me the code that displays the PDF file from the database in the adobe reader tool??

Richard MacCutchan 8-Oct-20 14:58pm

Does the tool have the ability to read the data direct from a memory stream? The problem you have is finding a way to render the PDF in your form. Maybe take a look at The Leading PDF Platform for Developers | iText[^],

adnan gharbi 8-Oct-20 15:09pm

yes, the tool have the ability to read the data direct from a memory stream
and the tool displays pdf file when I choose it from the disk but what I want is display it when I choose it after store it in database by clicking on it's name in datagridview

Richard MacCutchan 8-Oct-20 15:20pm

Then you need to study the documentation for the tool to see how you feed the data to it.

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)