Android Question Load an Image from MS Sql Server into customlistview

[SoftSpot]

I am having trouble loading an image (sql type: image) into my customlistview. Without the Image code all works fine, I would appreciate some here as I an running into walls.

#Region  Activity Attributes
    #FullScreen: False
    #IncludeTitle: True
#End Region

Sub Process_Globals
    'These global variables will be declared once when the application starts.
    'These variables can be accessed from all modules.
    Dim xui As XUI
    Type ItemValue (bmp As Bitmap,lbl As Label)
    
    
End Sub

Sub Globals
    'These global variables will be redeclared each time the activity is created.
    'These variables can only be accessed from this module.

    Private lsvOpp As CustomListView
    
    Private ImageView1 As B4XView
    Private lblName As B4XView
    
End Sub

Sub Activity_Create(FirstTime As Boolean)
    'Do not forget to load the layout file created with the visual designer. For example:
    Activity.LoadLayout("frmOperators")
    
    
    Dim rsOp As JdbcResultSet
        
    rsOp = modDB.Sql1.ExecQuery ("select name,surname,grid,img from Operator where grid > 0 order by name")
    
    Do While rsOp.NextRow
        
            
        '**********************
        Dim p As B4XView = xui.CreatePanel("")
        p.SetLayoutAnimated(0,0,0,100%x,120dip)
        p.LoadLayout("listOps")
        
        lblName.Text = rsOp.GetString("name").Trim
        
        'to load the image
        Dim Buffer() As Byte
        If rsOp.GetBlob("img") <> Null Then
            Buffer = rsOp.GetBlob("img")
            Dim InputStream1 As InputStream
            InputStream1.InitializeFromBytesArray(Buffer, 0, Buffer.Length)
            Dim bmp As Bitmap
            bmp.Initialize2(InputStream1)
            InputStream1.Close
        End If
        
        lsvOpp.Add(p,"")
    Loop
    

End Sub


Sub Activity_Resume

End Sub

Sub Activity_Pause (UserClosed As Boolean)

End Sub

 

[Erel]

You are not doing anything with 'bmp'.
I guess that you need to set it.

Making synchronous requests from a remote database is a BIG mistake.
You should switch to the async methods.

If it is a new project then you should use B4XPages. It will make many things simpler.

 

[SoftSpot]

Thanks Erel, this is my first project, trying to put things together, but definitely not the last. Will have a look at B4XPages.