Android Question How to read blob field from SQL Server and display bitmap in Imageview ?

[sukudxb]

Hi,

I need to read an image filed from Sql Server database and show the image in ImageView. Can any body help me please. I have created a web service to read data from the server. I am getting all other fields without any problem, but I don't have any idea how to convert the image field to bitmap and display it in image view.

I am using HttpUtils to read data from Sql Server, and the data is returned to me as JSON String. Anybody please help me.

 

[NFOBoy]

I use similar to this for audio files, should work for your images?

    Dim cursor1 As Cursor
  
'need to get the blob into a cursor
cursor1 = SQL1.ExecQuery("Put Query Here to get your blob'")
    cursor1.position = 0
'now need to get the data from the cursor into a Buffer
    Dim Buffer() As Byte 'declare an empty byte array

'move the cursor info into the Buffer
    Buffer = cursor1.GetBlob("Insert Name of the field that has your blob in it here")
'get the Buffer into a Stream
    Dim ImageInStream As InputStream
    ImageInStream.InitializeFromBytesArray(Buffer, 0, Buffer.Length)
'  ImageInStream holds the data.. need to get it into a bitmap
  
    Dim iv As ImageView
    Dim thisBitmap As Bitmap
    iv.Initialize("iv")
    thisBitmap.Initialize2(ImageInStream)
    iv.Bitmap = thisBitmap
'close the stream
ImageInStream.Close

 

[Erel]

You will need to read the blob in your web service, convert it to base64 string and then add it to the json response. On the device use StringUtils to decode the base64 to a bytes array.

 

[Gabino A. de la Gala]

I'm trying like this:

Dim ListOfMaps As List
                Dim b() As Byte
                Dim s As StringUtils
               
                ListOfMaps = parser.NextArray 'returns a list with maps
                If ListOfMaps.Size > 0 Then
                        ' Inicializo la copia de los datos locales...
                        InicializarTablaLocal(Main.LISTA_FOTOS)
                       
                        For i = 0 To ListOfMaps.Size -1
                            ProgressBar1.Progress=Round(ListOfMaps.Size / i+1)
                            Dim mapaAux As Map
                            mapaAux = ListOfMaps.Get(i)
                            b = s.DecodeBase64(mapaAux.Get("FOTO"))
                            mapaAux.Put("FOTO", BytesToString(b, 0, b.Length, "iso-8859-1"))
                        Next
                       
                        ' Inserto los datos obtenidos del servidor para la copia local
                        DBUtils.InsertMaps(Sql1, "FOTOS", ListOfMaps)
                        Label2.Text = ListOfMaps.Size
                        ToastMessageShow("FOTOS Insertadas: " & (ListOfMaps.Size), True)
                        MenuSincronizar.FotosImportadas = ListOfMaps.Size
                    Else
                        ToastMessageShow("Error: " & Job.ErrorMessage, True)
                        ToastMessageShow("Error: No se obtuvieron registros", True)
                End If

But I think, it doesn't work correctly.

Can anybody help me?

Sorry for my poor English. I'm Spanish.

 

[Erel]

Please start a new thread for this question.

 

[Gabino A. de la Gala]

Please start a new thread for this question.

Done

http://www.b4x.com/android/forum/th...-from-firebird-and-store-it-on-sqllite.32575/