Save image uploaded to picturebox to mysqldatabase as bytes

Question

0.00/5 (No votes)

See more:

I'm trying to properly save image that will be uploaded to picturebox by user and should be saved to database after clicking save button.

for the line of code below it says image1 does not contain a definition for save.

Image1.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
                    data = ms.ToArray();

What I have tried:

//this is my code for uploading the image to picturebox which is (image1)

{
               string folderPath = Server.MapPath("~/Files/");

               //Check whether Directory (Folder) exists.
               if (!Directory.Exists(folderPath))
               {
                   //If Directory (Folder) does not exists Create it.
                   Directory.CreateDirectory(folderPath);
               }

               //Save the File to the Directory (Folder).
               FileUpload1.SaveAs(folderPath + Path.GetFileName(FileUpload1.FileName));

               //Display the Picture in Image control.
               Image1.ImageUrl = "~/Files/" + Path.GetFileName(FileUpload1.FileName);
           }

//this is basic code I tried to insert into database

try
          {

              byte[] data;
              using (MemoryStream ms = new MemoryStream())
              {
                  Image1.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
                  data = ms.ToArray();
              }
              {

              using (MySqlConnection con = new MySqlConnection(myconstring))
                  {
                      con.Open();
                      using (MySqlCommand command = new MySqlCommand("INSERT INTO image (picture) VALUES (@IM)", con))
                      {
                          command.Parameters.AddWithValue("@IM", data);
                          command.ExecuteNonQuery();
                      }
                  }
              }

//this is my code for selecting the image from the database to display in picture box which works fine when I insert picture directly into the database and not from the webpage.

byte[] bytes = (byte[])command.ExecuteScalar();

             string strBase64 = Convert.ToBase64String(bytes);

             if (strBase64 != null)
             {
                 prvimage.ImageUrl = "data:Image/png;base64," + strBase64;
             }
             else
             {
                 Response.Write("Must upload an Image");
             }

Posted 5-Aug-19 0:35am

milepredy

Updated 11-Aug-19 9:27am

v3

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)

Richard Deeming · Answer 1 · 2019-08-08T06:41:00

The Image control[^] does not contain a Save method. But you don't need one - it's displaying an image from your server's disk.

C#

string fileName = Server.MapPath(Image1.ImageUrl);
if (string.IsNullOrEmpty(fileName))
{
    // TODO: Display an error to the user
    return;
}

byte[] data = File.ReadAllBytes(fileName);

using (MySqlConnection con = new MySqlConnection(myconstring))
using (MySqlCommand command = new MySqlCommand("INSERT INTO image (picture) VALUES (@IM)", con))
{
    command.Parameters.AddWithValue("@IM", data);
    
    con.Open();
    command.ExecuteNonQuery();
}

NB: You'll want to validate that the uploaded file is actually an image. You'll also want to check that the filename provided by the user doesn't contain any characters which aren't valid in a Windows filename. Never trust user input! :)

OriginalGriff · Answer 2 · 2019-08-05T00:39:00

Solution 1

No, that won't work: Why do I get a "Parameter is not valid." exception when I read an image from my database?[^] - it's exactly the same problem you are having, except you will need to convert the byte array to a Base64 string before you save it.

Posted 5-Aug-19 0:39am

OriginalGriff

Comments

milepredy 5-Aug-19 6:45am

I've been to that page, you can even tell from the similar parameters. It doesn't work for me as I get error with
image1.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
data = ms.ToArray();

which say's image1 does not contain definition for Save.

milepredy 5-Aug-19 6:45am

the solution on that page is one of the many solutions I have tried.
most of the solutions are desktop based applications. This is a Web app...

ramod kaushan · Answer 3 · 2019-08-11T09:27:00

SqlCommand cmd = new SqlCommand(") values()", cnn);
                cmd.CommandType = CommandType.Text;

 cnn.Open();

if (pictureFace.Image != null)
                    {
                        ms = new MemoryStream();
                        pictureFace.Image.Save(ms, ImageFormat.Jpeg);
                        byte[] photo_aray = new byte[ms.Length];
                        ms.Position = 0;
                        ms.Read(photo_aray, 0, photo_aray.Length);
                        cmd.Parameters.AddWithValue("@Image", photo_aray);
                    }
                    
                    cmd.ExecuteNonQuery();
}

Save image uploaded to picturebox to mysqldatabase as bytes

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0