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

Sai Yang

8y2.1kVisual Basic .NET

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.

16 Replies

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

Maen Badwan8y ago
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!
0
Rafnas T P8y ago
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)+")
-1
Amit Gupta8y ago
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/
0
Sai Yang8y ago
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");
0
Amit Gupta8y ago
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.
0
Sai Yang8y ago
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
0
Amit Gupta8y ago
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.
0
Piyush Pansuriya8y ago
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;
+1
Sai Yang8y ago
I using winform
0
Sai Yang8y ago
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?
0
Amit Gupta8y ago
The correct form of converting image to byte[] has been shown in the below reference http://net-informations.com/q/faq/imgtobyte.html
0
Amit Gupta8y ago
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
0
Piyush Pansuriya8y ago
Add class to use BitmapImage
using System.Windows.Media.Imaging;
+1
Sai Yang8y ago
Before I insert the image, I convert this image to byte or binary into database sql server 2012
0
Sai Yang8y ago
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.
0
Piyush Pansuriya8y ago
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;
+2