How to save and retrive image from/to picture box

mansoor altaf

hi.

i have selected the image using openfiledialog and loaded it to the picturebox in c# desktop app.

now i want to save the image, while saving the image it raises the exception that [] , these brackets are invalid parameters.

my code is.

MemoryStream stream=new MemoryStream();
pictureBox1.Image.Save(stream,System.Drawing.Imaging.ImageFormat.Jpeg);
pic=stream.ToArray();

here pic is of byte[] type. which is class level variable.

then i store pic in insert query like this.

string str = "insert into branches (branchcode,branchname,address,landlinecell,picture,description) values(" + branchcode + ",'" + branchname + "','" + address + "','" + landline + "'," + @pic+ ",'" + description + "')";

and then send the query to my save method to do the insertion operation.

what is the problem??

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Marvin Reid3y ago
Another solution is you can use the RasterCodecs class to load and save your file using the byte array. After conversion you can then pass the stream output for use in the database. Here is some quick code that demonstrates this:
```
byte[] bytes = File.ReadAllBytes(@"Path to file");
using (MemoryStream ms = new MemoryStream(bytes))
{
   RasterCodecs codecs = new RasterCodecs()
   ms.Position = 0;
   RasterImage image = codecs.Load(ms); // Image loaded from memory
   codecs.Save(image, ms, RasterImageFormat.Jpeg, 0); // Save to memory
}
```
https://www.leadtools.com/help/sdk/tutorials/dotnet-console-load-and-save-images.html
Prabhu Raja15y ago
Hi,

byte[] data= (byte[]) dr[0]; // check data is null or not by using Breakpoint.
MemoryStream strm = new MemoryStream();
strm.Write(data, 0, data.Length);
strm.Position = 0;
System.Drawing.Image img = System.Drawing.Image.FromStream(strm);
BitmapImage bi = new BitmapImage();
bi.BeginInit();
MemoryStream ms = new MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
ms.Seek(0, SeekOrigin.Begin);
bi.StreamSource = ms;
bi.EndInit();
PictureBox1.Image = bi;
mansoor altaf15y ago
hi raja. sorry for annoying you. but i have already used this " Image myImage=Image.FromStream(ms) " but it gives me "invalid parameter exception" i dont know y ?? plz help
Prabhu Raja15y ago
change The line From

Bitmap myImage=Bitmap.FromStream(ms);

To

Image myImage=Image.FromStream(ms);
mansoor altaf15y ago
hi Raja. i have tried your code , but it gives exception at design time which is "Error 1 Cannot implicitly convert type 'System.Drawing.Image' to 'System.Drawing.Bitmap'. An explicit conversion exists (are you missing a cast?) " i have tried many other ways but than it gives "invalid parameter exception " by using other methods. plz help. thx
Prabhu Raja15y ago
You can reverse the Conversion Process as ,

SqlConnection con = new SqlConnection("Your Connection String");
con.open();
SqlCommand cmd = new SqlCommand("SELECT pictureColumn FROM TableName", cn); //Change According to Your needs
SqlDataReader dr;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
While( dr.Read())
        {
    // Get Image as
  byte[] getimage = (byte[]) dr[0]; // Change Index According to Your Select Query
          MemoryStream ms = new MemoryStream(getimage);
          Bitmap myImage=Bitmap.FromStream(ms);
          PictureBox1.Image = myImage;
}
dr.Close()

-----------------------------------------------------------
If this helps you, then mark as "Correct Answer"
Thank You
mansoor altaf15y ago
hi Raja. thanks my query now inserts successfully. please also inform me the way how to retrieve image from database and than show in the picture box. as i am experiencing some problems to do so. thx in advance
Prabhu Raja15y ago
Try this, Covert Stream to byteArray.

public static byte[] ReadFully(Stream input)
{
byte[] buffer = new byte[16*1024];
using (MemoryStream ms = new MemoryStream())
{
int read;
while ((read = input.Read(buffer, 0, buffer.Length)) > 0)
{
ms.Write(buffer, 0, read);
}
return ms.ToArray();
}
}

And then, your code as

MemoryStream stream=new MemoryStream();
pictureBox1.Image.Save(stream,System.Drawing.Imaging.ImageFormat.Jpeg);
byte[] pic=ReadFully(stream);

You Query As

string str = "insert into branches (branchcode,branchname,address,landlinecell,picture,description) values(" + branchcode + ",'" + branchname + "','" + address + "','" + landline + "'," + @pic+ ",'" + description + "')";
SqlCommand cmd = new SqlCommand (str);
cmd.Parameters.Add ("@pic", pic);
cmd.ExecuteNonQuery ();

--------------------------------------------------------------
If this helps you, then mark as "Correct Answer"
Thank You