How to save an image into a database?

Question

I am using WPF to insert an image to my MySQL database. I can upload the file to image control but I don't know how to save it.

Here is what I've done so far. The emp_image is the image control that displays the photo.

private void btn_save_image_click(object sender,...)   
{   
    Mysqlconnection cn= new mysqlconnection(connectionstring);    
    byte[] imagedata;    
    imagedata=File.ReadAllBytes(emp_img);  //..here is error,it says has invalid arguments..//
    mysqlcommand= new mysqlcommand("insert into dep_table(photo)values(?data)",cn);    
    cmd.parameters.addwithvalue("?data", imagedata);    
    cn.open();    
    cmd.executeNonQuery();    
    cn.close();
}

It would be a better idea to store the **path** to the image as opposed to the image itself. — Mike Eason, Sep 21 '15 at 08:54
@Nikita emp_img is an image control where image is shown and i want to save that image to database table — codefan, Sep 21 '15 at 08:55
what is the Imagesource look like for the control. Is it a path/URI??? add an example — Nikita Shrivastava, Sep 21 '15 at 08:56
`emp_img` is a control and not an image file --> you should put the file path into that function. A suggestion is, you should not save image in database. You should store the image on disk. And just save the file path to that image to database. — IMPENTA, Sep 21 '15 at 08:57
question is not related to database at all, you have a problem reading a file from disk, probably because you are specifying an invalid path — Felice Pollano, Sep 21 '15 at 08:58
@MikeEason@Nikita the image source is : emp_img.source= new bitmapImage(new Uri(dlg.FileName)); — codefan, Sep 21 '15 at 09:00

score 1 · Accepted Answer · edited Sep 21 '15 at 09:46

1

you need to convert the image source to byte[] :

public static byte[] ImageToArray(BitmapSource image)
{
    var encoder = new JpegBitmapEncoder();
    encoder.Frames.Add(BitmapFrame.Create(image));

    using (var stream = new MemoryStream())
    {
        encoder.Save(stream);
        return stream.ToArray();
    }
}

Then, call the function:

imagedata = ImageToArray((BitmapSource)emp_img.Source);

edited Sep 21 '15 at 09:46

Clemens

123,504
12
155
268

answered Sep 21 '15 at 09:16

Nikita Shrivastava

2,978
10
20

wbmp.SaveJpeg is not availbale! is there any namespace missing? – codefan Sep 21 '15 at 09:23
System.Windows.Media.Imaging – Nikita Shrivastava Sep 21 '15 at 09:24
I already have it. but it says that it doesn't contain a definition for 'SaveJpeg' – codefan Sep 21 '15 at 09:29
1

SaveJpeg is Windows Phone. – Clemens Sep 21 '15 at 09:33
1

See [this answer](http://stackoverflow.com/a/554455/1136211), but replace `memStream.GetBuffer()` by `memStream.ToArray()`. – Clemens Sep 21 '15 at 09:38
Yes, found it.checking for alternative using Encoders – Nikita Shrivastava Sep 21 '15 at 09:38
Also use `BitmapSource` instead of `BitmapImage` as argument type (so that it also supports `BitmapFrame`). Cast the `Image.Source` property to `BitmapSource`. – Clemens Sep 21 '15 at 09:40

score -1 · Answer 2 · answered Sep 21 '15 at 08:57

-1

Seems you are not passing the file path.

Please check File::ReadAllBytes Method

Should be something like

var imagedata=File.ReadAllBytes(filepath);

answered Sep 21 '15 at 08:57

huMpty duMpty

14,346
14
60
99

4

this is better a comment than a reply – Felice Pollano Sep 21 '15 at 08:59

How to save an image into a database?

2 Answers2