I want to save image in database

Question

I have an image on a page, e.g <img id="img3" runat="server" src="image.jpg" width="200" height="200"/> and I'd like to save the image referenced by the src attribute in my database using stored procedure.

I should convert the image to binary first. Here is what I have so far:

    Stream fs = FileUpload1.PostedFile.InputStream;

    BinaryReader br = new BinaryReader(fs);
    Byte[] bytes = br.ReadBytes((Int32)fs.Length);

    cmd.Parameters.AddWithValue("@img", byte);

But the thing is that I don't want to save the uploaded image FileUpload1.PostedFile.InputStream, I want to save the image that I had its src.

Is there a way to put the image src in stream so that I can save it or what is the right way for doing that?

Are you saying the filename of the image becomes FileUpload1.PostedFile.InputStream once it's deserialized from the database? — SpaceSteak, Sep 14 '15 at 11:43
BTW! Its not recommended to save images into database, use folder instead. — NASSER, Sep 14 '15 at 11:43
i have an image on my web page i want to save it in database but the problem is that "Stream fs = FileUpload1.PostedFile.InputStream;" saves the uploaded image not the one that i want for ex: i have i want to save this image to database not the uploaded one — H.A.M, Sep 14 '15 at 11:55

score 3 · Answer 1 · answered Sep 14 '15 at 11:53

Generally it is not recommended to store images in Database or any other type of files in RDBMS. What is most effective way, to store the file over disk on server, and store that path in your table.

So whenever you need to reference that image/file, then fetch the path from the database, and read the file from disk. This broadly has following two benefits.

Removes the extensive conversion process (from image to binary and vice-versa).
Helps to read the image directly (soft-read).

score 1 · Answer 2 · edited May 23 '17 at 12:14

1

Saving an image in the database is not recommanded, but if you insist on saving it in your database you can convert the image to base64, then save the base64 string in your database.

using (Image image = Image.FromStream(FileUpload1.PostedFile.InputStream))
{                 
    using (MemoryStream m = new MemoryStream())
    {
        image.Save(m, image.RawFormat);
        byte[] imageBytes = m.ToArray();

        // Convert byte[] to Base64 String
        string base64String = Convert.ToBase64String(imageBytes);
        //Now save the base64String in your database
    }                  
}

And to convert it back from base64 to an image:

public Image GetImageFromBase64String(string base64String)
{
    byte[] bytes = Convert.FromBase64String(base64String);
    Image image;

    using (MemoryStream ms = new MemoryStream(bytes))
    {
        image = Image.FromStream(ms);
    }

    return image;

I combined some code from converting a base 64 string to an image and saving it and from Convert image path to base64 string .

edited May 23 '17 at 12:14

Community

1
1

answered Sep 14 '15 at 11:52

Shaked Dahan

402
5
22

This shouldn't happen at very first place. If you are dealing with good amount of files, then this way will be more process extensive at both, code level as well as at DB level. – Amnesh Goel Sep 14 '15 at 11:54
Im just giving him what he asked for, whether its good or not is up to him to decide. – Shaked Dahan Sep 14 '15 at 11:59
`Base64String` takes more memory than image actual size. – NASSER Sep 14 '15 at 12:01
Yes by seeing your answer, I can see that. But at the same time, it is our duty to redirect user for the right approach, not for what is asked unless restricted by the business requirement. However in this case, he can simply deal with file-system instead of Database. Rest up to you sir. – Amnesh Goel Sep 14 '15 at 12:01
ok thanks a lot guys :) im a new developer and i don't have a good experience yet thanks for helping – H.A.M Sep 14 '15 at 12:35
@AmneshGoel youre absolutly right, ill edit my answer. – Shaked Dahan Sep 14 '15 at 15:08

I want to save image in database

2 Answers2