Adding images to database

Question

0.00/5 (No votes)

See more:

I need to add some images to my database table.How can I do that(How to convert images into binary). Give me an answer with an example.with a small example application.

Posted 4-Dec-12 16:25pm

NISHAN SANDEEPA

Updated 4-Dec-12 16:27pm

v2

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)

Abhinav S · Accepted Answer · 2012-12-04T17:00:00

Solution 1

Assuming you are using SQL Server as the database, here are some links that might help you.
You can use the image column.

Try
Storing and Retrieving Images from SQL Server Using Strored Procedures and C#.net[^]
Store or Save images in SQL Server[^]
http://www.mindstick.com/Blog/184/Save%20image%20in%20SqlServer%20usin[^]

Posted 4-Dec-12 17:00pm

Abhinav S

Comments

Espen Harlinn 11-Dec-12 17:53pm

5'ed!

Abhinav S 12-Dec-12 0:52am

Thank you Espen.

Wendelius 12-Dec-12 1:21am

So true :)

Wendelius · Accepted Answer · 2012-12-04T17:12:00

Solution 2

To add to Abhinav's answer, if you want to use FileStream for the images, have a look at How to store and fetch binary data into a file stream column[^]

Posted 4-Dec-12 17:12pm

Wendelius

Comments

Espen Harlinn 11-Dec-12 17:53pm

5'ed!

Wendelius 12-Dec-12 0:16am

Thanks :-)

Abhinav S 12-Dec-12 0:52am

5 of course!

Wendelius 12-Dec-12 1:22am

Thanks :)

Kushan Randima · Accepted Answer · 2012-12-04T17:28:00

Dear Nishantha,

I hope that you are using SQL Server to store the images. Here is the code that I use in my project to insert profile pictures to the Database.

C#

string FileName = "";
Byte[] img = new byte[0];

FileDialog filedialog = new OpenFileDialog();
filedialog.ShowDialog();
FileName = filedialog.FileName;
yourPictureBox.ImageLocation = FileName;

if (FileName.Length > 0)
{
    FileStream fs = new FileStream(FileName, FileMode.Open);
    img = new Byte[fs.Length];
    fs.Read(img, 0, (int)fs.Length);
    fs.Close();
}

Kushan Randima
Software Engineer
DigiteQ Solutions PVT LTD