How to save and retrive image from/to picture box

Question

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??

Marvin Reid · Answer

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 Raja · Answer

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 altaf · Answer

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 Raja · Answer

change The line From Bitmap myImage=Bitmap.FromStream(ms); To Image myImage= Image .FromStream(ms);

mansoor altaf · Answer

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 Raja · Answer

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 altaf · Answer

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 Raja · Answer

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(streamSystem.Drawing.Imaging.ImageFormat.Jpeg); byte[] pic=ReadFully(stream); You Query As string str = insert into branches (branchcodebranchnameaddresslandlinecellpicturedescription) 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