Jump to content

SQL Image bin data Convert to picture


Recommended Posts

Picture in SQL Server Tab which format is image bin,how to convert to picture format(BMP、JPGorPNG) and display in labview.

Some one have idea?

 

Thanks

I'm not familiar with the BIN file format for images.  It maybe a stream, which you can use with the Windows PictureBox.  If this is the case you can create a .NET Control in LabVIEW to open it.  If this isn't the case you may need to post an example BIN file so we can help understand what the file format is and how to view it.

Edited by hooovahh
Link to comment
I'm not familiar with the BIN file format for images.  It maybe a stream, which you can use with the Windows PictureBox.  If this is the case you can create a .NET Control in LabVIEW to open it.  If this isn't the case you may need to post an example BIN file so we can help understand what the file format is and how to view it.

 

I think he just means it is binary (BLOB in database speak). In which case it will be whatever format the original image was and he just needs to save it to a file with the right extension and play with the picture toolkit. I also assume by his reference to "SQL Server Tab" that he can see something in a database viewer of some description. Of course "assume" makes an "ass" out of "u" and "me" :)

Edited by ShaunR
Link to comment

Thaks a lot  ,hooovahh & ShaunR

ShaunR is right,it is BLOB.

In fact,the picture is saved in SQL server by .NET which is a Production and quality control program,Similar MRP.I  made  some  auto test  equipments which programed by labview  and need to integrate into the system.when the operator login,program need to find and get  the operater's pitcure in SQL server,display on the program 's front panel Indicate who is using. 

This is a very difficult issue for me ,because I  only write LabVIEW program,others not。

 

ShaunR,Do you have relevant examples?or detailed methods?

 

Thanks again!

Link to comment
Thaks a lot  ,hooovahh & ShaunR

ShaunR is right,it is BLOB.

In fact,the picture is saved in SQL server by .NET which is a Production and quality control program,Similar MRP.I  made  some  auto test  equipments which programed by labview  and need to integrate into the system.when the operator login,program need to find and get  the operater's pitcure in SQL server,display on the program 's front panel Indicate who is using. 

This is a very difficult issue for me ,because I  only write LabVIEW program,others not。

 

ShaunR,Do you have relevant examples?or detailed methods?

 

Thanks again!

 

What are you using (in LabVIEW) to query the database? SQL Toolkit? If you have already retrieved the blob data then you only need to save it to a binary file using the "Write to Binary File.vi" primitive. Once that is done, you can load it into a LV picture indicator with the "Read [JPG/PNG/BMP] File.vi" in the graphics format palette As Ton is intimating. You need to know the format (jpg, bmp, png) to load it back up because you need to use the right LV vi.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.