Assign SQL Blob to an Image view

[Cableguy]

How do I assignd the contents of a SQL Blob to an Imageview?

 

[Cableguy]

Ok, so I started trying to solve this one by myself, as I always do...
I came up with this:

      Buffer = Cursor1.GetBlob("Image")
      Dim Canvas1 As Canvas
      Canvas1.Initialize(ImageView1)
      Dim IN As InputStream
      IN.InitializeFromBytesArray(Buffer,0,Buffer.Length)
      IN.Close
      Msgbox(buffer.Length,"Image lenght")
      Msgbox(In.BytesAvailable,"available")
      Canvas1.Bitmap.Initialize2(IN)
      ImageView1.Bitmap = Canvas1.Bitmap

I use the two message boxes to be sure that the inputstream has the same size as the Buffer...so far so good, but I get a system exceptions tell me that it cannot load the image...I'm thinking bout 80% of my code i correct, and my logical thinking too, but I cannot see were is the fault for the Blob to not show

 

[Erel]

The SQL tutorial code does exactly this: http://www.b4x.com/forum/basic4android-getting-started-tutorials/6736-sql-tutorial.html#post39108

 

[Cableguy]

Sorry, missed that... still, my code is very similar, almost identical, so waht is my mistake?
the only ajor diference I can see is the closing of the stream, being done AFTER assigning it to the Imageview...

Edit:
I just tryed the sample code, duelly altered to match my needs, and I get the exact same error...

 

[Erel]

Are you able to run the original tutorial code properly?

 

[Cableguy]

think so, wen I compile I get a big Smiley as the activity background...


I'm thinking this is somethisngdue to my db...
I am using SQLite Administrator, has I've always done...
Can you point me to any other ease to use db creator/edito/admin free software?

 

[Erel]

You can try SQLite Expert: SQLite Expert - A powerful administration tool for your SQLite databases

In this case the image is stored to the database in the InsertBlob method.

 

[Cableguy]

Thanks EREL, downloading as we speak...

 

[Cableguy]

Done! It turns out to be something in the way SQLite Adinistrator handles the Blob fields...
All working now, Thanks EREL!

 

[aklisiewicz]

Is there any example how to load BLOB images into a ListView or ScrollView instead, or perhaps some other method to diplay several images (that user can scroll Up/Down OR Left/Right) ?

Arthur

 

[Erel]

This is an old thread. Please start a new one for this question.