Problem in saving image in Sql Database c#

Question

0.00/5 (No votes)

See more:

How to solve the error in the picture
https://www.dropbox.com/s/66zsy6s6olbx54l/questionimage1.png?m=[^]

My Database Stucture
https://www.dropbox.com/s/o8m98hlyy45enib/questionimage2.png?m=[^]

Posted 1-Mar-14 0:56am

agent_kruger

Add a Solution

1 solution

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)

OriginalGriff · Answer 1 · 2014-03-01T01:05:00

Solution 1

Make the field bigger.
The individual parts of a filename (i.e. each subdirectory along the path, and the final filename) are limited to 255 characters, and the total path length is limited to approximately 32,000 characters in NTFS - but you should keep the total length below 260 characters if your can aas older systems only allocate that much.

50 bytes is clearly not going to be enough.

And in future, if you want help, copy and paste your information, don't post links to snapshots - it shows you are lazy and don't care to help us to help you. Some people will not follow links to images at all, so you restrict the number of useful replies you may get.

Posted 1-Mar-14 1:05am

OriginalGriff

Comments

agent_kruger 1-Mar-14 7:10am

sorry sir, next time i will only paste the written matter.

OriginalGriff 1-Mar-14 7:28am

:thumbsup:

OriginalGriff 1-Mar-14 7:33am

Difficult: in theory, you *should* be ok with 260 bytes, as that is the "MAX_PATH" value that windows works with.
But...Do you trust that?
OK, I'm running Win7, and it won't let me create a folder path/filename combo longer than 260 characters, but it's a risk relying on it! (Remember, we have no control over Win9, or 10, or ...)
I'd probably go with 1024, or MAX just to be on the safe side, depending on how many items you expect to store. If it's a lot, then 1024, if it's a few, then MAX.
But 50? Nowhere near! :laugh: