how to insert a image in database ?

Question

0.00/5 (No votes)

See more:

hello friends,

please help me out,

how to insert an image in database through c#(upload a file) and also while retriving it should display in picturebox.

thanking you.

Posted 19-Dec-13 22:59pm

Mr.VJ

Add a Solution

Comments

An@nd Rajan10 20-Dec-13 5:01am

stored as binary...

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)

Karthik_Mahalingam · Answer 1 · 2013-12-19T23:03:00

Solution 1

Try this link, works fine.

http://forums.asp.net/t/1922364.aspx[^]

If you wanna store the image file in web server and save the image path in Db you can prefer this link
http://www.aspsnippets.com/Articles/Retrieve-images-using-a-file-path-stored-in-database-in-ASPNet.aspx[^]

Its better to store the images in web server instead of SQL server and save the file path in table column, if you are handling more number of images,
in case of less number of images you can save the image object in the SQL Server.

Posted 19-Dec-13 23:03pm

Karthik_Mahalingam

Comments

Vishal Pand3y 20-Dec-13 5:08am

it will be much better to store path instead of image take a 5 for that

Karthik_Mahalingam 20-Dec-13 5:11am

Thanks vishal :)

Aravindba 20-Dec-13 5:11am

this is bad idea in web application store a path in database,some time images deleted form folder ,then what u do,it will point out path,but there is no image ,then ?
better to store image in database as binary and retrive and save in temp folder and show in picture box

Vishal Pand3y 20-Dec-13 5:17am

@Aravindba performance wise storing image's path will be better. there are some disadvantages of it but if you want to store millions of image and storing path will be better
and if you are deleting images from folder then delete it's path from database to

Karthik_Mahalingam 20-Dec-13 5:20am

true...
@Arvaid , I am not forcing him store in Db or Web server.. it depends on the Images count...
they have to choose which suits for their requirement...

Aravindba 20-Dec-13 5:26am

thanx for ur way,but somebody manually deleted image form folder ? or u try to clean pc,that time u take backup of database only ,not folder or drive,i.e path may form all drives,then how u image path form databse will work ?,only u have binary formate,then only can get images,inn sql server have max space to store images as filestream

Thomas ktg · Answer 2 · 2013-12-19T23:07:00

Solution 2

Refer this link,
http://www.aspsnippets.com/Articles/How-to-save-insert-Image-in-Database-in-ASPNet-using-C-and-VBNet.aspx[^]

Posted 19-Dec-13 23:07pm

Thomas ktg

Gaurav Makwana · Answer 3 · 2013-12-20T00:27:00

Make one folder images in your web application and take varbinary datatype as variable in your backend(database)
its easy and work smoothly!

C#

protected void Button1_Click(object sender, EventArgs e)
       {
           if (FileUpload1.HasFile)
               try
               {
                   FileUpload1.SaveAs(Server.MapPath("~/your folder name/" + FileUpload1.FileName));
                   Label1.Text = "File name: " +
                        FileUpload1.PostedFile.FileName + "<br>" +
                        FileUpload1.PostedFile.ContentLength + " kb<br>" +
                        "Content type: " +
                        FileUpload1.PostedFile.ContentType;
                   filename.Text = FileUpload1.FileName;
               }
               catch (Exception ex)
               {
                   Label1.Text = "ERROR: " + ex.Message.ToString();
               }
           else
           {
               Label1.Text = "You have not specified a file.";
           }
       }