[C#] how to view image ????

Question

I have already convert a picture box to byte then insert into database as image datatype. The proble: I need to preview it on to the picturebox again when datagrid cellclick event. and I am using the following code: string stimg = "select images from tb_employee where Boolean='True' and id='" + classinfo.eid + "'"; DataTable dtimg = ClassConnection.getdata(stimg, "tbname"); if (dtimg.Rows.Count == 1) { try { MemoryStream ms; byte[] bviewimg = (byte[])dtimg.Rows[0]["images"]; ms = new MemoryStream(bviewimg); ms.Seek(0, SeekOrigin.Begin); picem.Image = Image.FromStream(ms); } catch { picem.Image = null; } } this doesn't work for me . What I can do next?? Any body has idea to solve this problem, please share it to me?> thank you in advance.

Piyush Pansuriya · Answer

Hello, Try this code: MemoryStream ms; byte [] bviewimg = ( byte [])dtimg.Rows[0][ "images" ]; ms = new MemoryStream(bviewimg); BitmapImage BitObj = new BitmapImage(); BitObj.BeginInit(); BitObj.StreamSource = ms; BitObj.EndInit(); picem.Image = BitObj;

Piyush Pansuriya · Answer

Try this code: MemoryStream ms; byte [] bviewimg = ( byte [])dtimg.Rows[0][ "images" ]; ms = new MemoryStream(bviewimg); ms.Write(bviewimg, 0, bviewimg.Length); ms.Position = 0; picem.Image = Image.FromStream(ms); OR MemoryStream ms; byte [] bviewimg = ( byte [])dtimg.Rows[0][ "images" ]; ms = new MemoryStream(bviewimg); ms.Write(bviewimg, 0, bviewimg.Length); Bitmap bitmap = new Bitmap(ms); picem.Image = bitmap;

Piyush Pansuriya · Answer

Add class to use BitmapImage using System.Windows.Media.Imaging;

Maen Badwan · Answer

The following article contains a full sample code that shows how to save and load images from-to database using native Microsoft classes: https://www.codeproject.com/Articles/33310/C-Save-and-Load-Image-from-Database If you already tried this approach and it doesn’t work, then the issue it is most likely related to the format or compression of the image you save-load from the database. For example, if the image format is not natively supported by Microsoft .NET classes (such as uncompressed TIFF), then the image will not be displayed even if the memory stream contains a valid data. In this case, you might need to use a programming toolkit that supports loading this type of images, convert it to one of the natively supported formats such as JPEG, PNG, BMP, etc. And then show it in the Microsoft .NET Picture Box control. You can try using LEADTOOLS .NET classes to load the image and resave it to a supported form as follows: RasterCodecs codecs = new RasterCodecs(); //Seek the memory stream object to the first byte ms.Seek(0, SeekOrigin.Begin) // Load the image from the memory stream RasterImage image = codecs.Load(ms); // Save the image back to a support format codecs.Save(image, outputFileName, RasterImageFormat.Png, 24); // Convert LEAD RasterImage object to Microsoft Image object System.Drawing.Image MainImage = Leadtools.Drawing.RasterImageConverter.ConvertToImage(LeadImage, ConvertToImageOptions.None); //View the image in the picture box control picem.Image = MainImage; I hope this helps!

Rafnas T P · Answer

hi, try this below string insert into table_employee (images) values('"+ImageToByte(picemployee)+"') here you have to remove single quates like below (not this '" but " ) string insert into table_employee (images) values("+ImageToByte(picemployee)+")

Amit Gupta · Answer

You can find many reference on this over the web, here is a quick reference https://www.completecsharptutorial.com/ado-net/insert-records-using-simple-and-parameterized-query-c-sql/

Sai Yang · Answer

I am not sure, I can implement with that again my insert statement is: string insrt ="insert into table_employee (images) values('"+ImageToByte(picemployee)+"' ; datatatble dt = getdata(insrt,"tbname"); messagebox.Show("insert image is successfull");

Amit Gupta · Answer

insert into table_employee (images) values('"+ImageToByte(picemployee)+"') The problem is here, you are storing it in a string format which makes your image corrupted. Use parameterized query to save the image. I am sure you know how to implement that.

Sai Yang · Answer

Hi Amit Gupta this is my code to convert image to byte public static byte[] ImageToByte(PictureBox pb) { byte[] Picb = null; MemoryStream ms = new MemoryStream(); if (pb.Image != null) { pb.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Png); } //skip: else { Picb = ms.ToArray(); ms.Close(); } return Picb; } calling method to save image to database insert statement like: string insert into table_employee (images) values('"+ImageToByte(picemployee)+"') picemployee is the picturebox of employee. If I use ImageToByte(picemployee.Image) this code system unread I am not sure this insert statement can be a problem on viewing image

Amit Gupta · Answer

You misunderstood my post, I was asking to share the code which you used to convert image to byte[] for saving image to database. I think the conversion method makes your image corrupted thats might the reason of not showing the image when fetched from database (as your code seems good). Just match your code wth the link that I had posted.

Sai Yang · Answer

I using winform

Sai Yang · Answer

I try using this twice methods to help but it seems not work or not display to the picturebox to me. the method1: public static Image bytArrayToImage( byte [] byteArrayIn) { System.IO.MemoryStream ms = new MemoryStream(byteArrayIn); Image returnImage = Image.FromStream(ms); return returnImage; } method2: public static Image LoadImage(Array ary) { Image YImage = null ; if (ary == null ) { return YImage; } System.IO.MemoryStream ms = new System.IO.MemoryStream(( byte [])(ary)); if (ms.Length > 0) { Image img = Image.FromStream(ms); YImage = img; } else { YImage = null ; } return YImage; } then I select from database like this and call the above method to help but I am not sure I put it in correctly. the select funtion like: private void loadimg() { if (classinfo.eid != "" ) { string stimg = "select images from tb_employee where Boolean='True' and id='" + classinfo.eid + "'" ; DataTable dtimg = ClassConnection.getdata(stimg, "tbname" ); if (dtimg.Rows.Count == 1) { try { byte [] bviewimg = ( byte [])dtimg.Rows[0][ "images" ]; picem.Image = bytArrayToImage(bviewimg); ////method 1 picem.Image=bytArrayToImage(bviewimg) //////method 2 } catch { picem.Image = null ; } } } } Test result give me that " the parameter is not valid" I think my method is correctly but I call it wrong in funtion select, is not it? help me. What is the problem now? and why?

Amit Gupta · Answer

The correct form of converting image to byte[] has been shown in the below reference http://net-informations.com/q/faq/imgtobyte.html

Amit Gupta · Answer

Before digging into the question , please mention which platform you are using ( winforms, wpf, web). Members having answer in wpf. Make sure the byte[] you had converted is in correct form, show that code because your code seems good

Sai Yang · Answer

Before I insert the image, I convert this image to byte or binary into database sql server 2012

Sai Yang · Answer

Hi Piyush Pansuriya I try your code given, but system doesn't read BitmapImage() Does it using any .dll or not ? I do not get your source code. please show me in more detail. thank you.