How to add a pdf file to SQL database in C# winforms

Question

1.00/5 (1 vote)

See more:

Hello!
I want to create a document turnover program. namely pdf, word, Excel, audio, video. Help me please with source code.

What I have tried:

I tried the blob but it didn't work

Posted 14-Feb-20 8:03am

Member 14625523

Updated 14-Feb-20 23:21pm

Add a Solution

3 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)

Patrice T · Answer 1 · 2020-02-14T23:22:00

Solution 3

Quote:
I tried the blob but it didn't work

Blob is not the problem. Your problem is somewhere else.
The blob datatype is specially designed for binary data, it means that when you read it, you get back exactly what was saved in it.
Binary large object - Wikipedia[^]

Posted 14-Feb-20 23:22pm

Patrice T

KarstenK · Answer 2 · 2020-02-14T22:57:00

Solution 2

You shouldnt do that, but develop a service which copy the files to a hard drive and delivers an unique file system.

Read this project report about a dms for some insights.

Posted 14-Feb-20 22:57pm

KarstenK

OriginalGriff · Answer 3 · 2020-02-14T08:42:00

"It didn't work" is one of the most useless problem descriptions we get: unfortunately we get it a lot.
It tells us nothing about what you tried, how you tried it, what happened when you tried it, what you did to find out why, or what you need from us.
So in future, please show us code you tried and what exactly happened when you did...

But most times, when you try to store info in a DB and it doesn't work, it's because you are doing it wrong, and images normally show it as a problem when you try to fetch them from the db with a "Parameter not valid error" - other file types will give different errors, but for the same reasons.

So start here: Why do I get a "Parameter is not valid." exception when I read an image from my database?[^] - it's image based, but it's applicable to any array of data you try to store.