Storing images in C# Windows application

Question

0.00/5 (No votes)

See more:

hello,
i am developing windows application supporting several users on LAN. among the data to be stored and retrieved is pictures, so:
should i store them inside database (SQL server), or only to store their path inside database and store images on HD?

also what image format should i choose (JPEG, PNG, etc)?

Thanks Alot
Samer

Posted 27-Dec-11 2:59am

samer.m.zain

Add a Solution

3 solutions

Solution 3

I prefer File system. Check this link for more details. And yes the below link is about web application but you just need minor changes to use that in win application(Loading pictures into Picturebox).
Storing Uploaded Files in a Database or in the File System with ASP.NET[^]

Posted 27-Dec-11 5:03am

thatraja

Comments

Uday P.Singh 27-Dec-11 11:39am

Agree 5+

Wendelius 28-Dec-11 15:00pm

This was an interesting link to read, my 5.

The disadvantages with the database were mainly speed and easy access. Do you feel that these are still correct even if Filestream is used?

thatraja 28-Dec-11 21:10pm

Ofcourse, We need permission for those files on webserver. Also the relationship between the records & images

Wendelius 29-Dec-11 0:42am

Yes, the permissions must be given but the relationship with the record is 'automatically' created since the image (in this case) is stored to the database but actually placed separately on the filesystem by SQL Server engine.

I'll have to think about this :)

Espen Harlinn 30-Dec-11 9:34am

5'ed!

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)

#realJSOP · Accepted Answer · 2011-12-27T03:01:00

Solution 1

I vote that you store them in the database. If you don't need transparency, I would use JPG because they can compress to a MUCH smaller size.

Posted 27-Dec-11 3:01am

#realJSOP

Comments

thatraja 27-Dec-11 12:03pm

If you don't need transparency, I would use JPG because they can compress to a MUCH smaller size
Agree, 5!

Espen Harlinn 30-Dec-11 9:33am

5'ed!

Wendelius · Accepted Answer · 2011-12-27T03:06:00

Solution 2

As a personal opinion, I would put them inside the database. Propably using Filestream to more easily handle backups and transactions (if interested, see: How to store and fetch binary data into a file stream column[^]).

JPG as the image format sounds tempting because of the size as JSOP pointed out.

Posted 27-Dec-11 3:06am

Wendelius

Comments

thatraja 27-Dec-11 12:03pm

5!

Wendelius 27-Dec-11 13:39pm

Thanks :)

Espen Harlinn 30-Dec-11 9:34am

5'ed!

Wendelius 30-Dec-11 10:23am

Thanks :)