Hi all,

Just wondered if this is possible I have some images that are stored in the database as a base64 encoding (so string) but this was encoded by a vb.net application

Do I have to convert the image back into a file before loading it to the picture box or can I load the image to the picture box direct from a memory of the image?

…try this command line:  

 I tried

FrmPLUList.picturebox1.image.fromstring(frombase64(PLUDataResult!button_image))

Im getting a error message on the line saying Null object in PLUFunctions

I can list the base64 code if you want

Yes, attach the base64 string file or paste this string, for testing.

That is the base64 code

AS the images are loading on the VB.net version This is the code I am using

Well, we have 2 problems.

1) About the "Null object" error it is caused by the command line, which :? I suggested you.
It should be changed as follows:
2) The string of values, you pasted here, is represented by single ASCII numeric characters. Each pair of these individual numeric characters "graphically " represents a numeric value in hexadecimal format.
We must, therefore, convert any pair of ASCII numeric characters into its corresponding actual numeric value and then into the corresponding string value.

Well, here a basic example using your provided data:
Well, with this my code I can see in "PictureBox" a little image with two bananas.   

I think I have a issue with the recall of the String fromt he database


When I recall the string I get


it is not the same as what I have in the database



This is what I am using to recall the image BLOB

ANd yes the image is a small pic of a some bananas

When I run your code onm the string i have I get the following error message "Missmatch: Wanted Integer, Got Null instead"

I did convert your code to a Function


did I convert your code wrong?

AndyGable said

I think I have a issue with the recall of the String from the database

When I recall the string I get

Code

"/9j/4AAQSkZJRgABAQEAYABgAAD......etc...."

it is not the same as what I have in the database

Code

0x2f396a2f344......etc.....

Yet, the string, attached by you, that you receive from the database, consists of correct string values, each corresponding with a byte-value of the image.
Basically, by my conversion loop, present in my code above, I get those real string characters.
In fact, for example, by converting the first two numeric characters "2" and "f" using my loop, we obtain the ASCII string character "/".

So, if I use this character string:
I don't need to run the conversion loop, present in my code above.
In short, I can write:
…and again I see those two bananas in the PictureBox.

AndyGable said

This is what I am using to recall the image BLOB

Sorry, I can't help you here, as I never use database, and therefore know  :?  nothing about them.

AndyGable said

When I run your code onm the string i have I get the following error message "Missmatch: Wanted Integer, Got Null instead"

In which line of your function's code does the error message appear?

vuott said

AndyGable said

I think I have a issue with the recall of the String from the database

When I recall the string I get

Code

"/9j/4AAQSkZJRgABAQEAYABgAAD......etc...."

it is not the same as what I have in the database

Code

0x2f396a2f344......etc.....

Yet, the string, attached by you, that you receive from the database, consists of correct string values, each corresponding with a byte-value of the image.
Basically, by my conversion loop, present in my code above, I get those very string characters.
In fact, for example, by converting the first two numeric characters "2" and "f" using my loop, we obtain the ASCII string character "/".

So, if I use this character string:

Code

"/9j/4AAQSkZJRgABAQEAYABgAAD......etc...."

I don't need to run the conversion loop, present in my code above.
In short, I can write:

Code (gambas)

1. Public Sub Form_Open()
2.  
3.   Dim s As String = "/9j/4AAQSkZJRgABAQEAYABgAAD......etc....etc..."
4.  
5.   PictureBox1.Image = Image.FromString(FromBase64(s))
6.  
7. End

…and again I see those two bananas in the PictureBox.

AndyGable said

This is what I am using to recall the image BLOB

Sorry, I can't help you here, as I never use database, and therefore know  :?  nothing about them.

AndyGable said

When I run your code onm the string i have I get the following error message "Missmatch: Wanted Integer, Got Null instead"

In which line of your function's code does the error message appear?

Thank-you Thank-you Thank-you updating the way the function loads the image worked perfectly I can see the images now

AndyGable said

… updating the way the function loads the image worked perfectly ….

Ehmmm… practically… what did you do?

 Once you explain that what I was getting from the database was string data correctly formatted I just changed it to be

ImageFile.Image = Image.fromstring(frombase64(image string))