Android Question Custom Grid View from SQL image (blob)

[Matteo Granatiero]

I see this Custom Grid View Example and Library , I tried to connect through the Sql Database Cursor.Getstring but without success. For ListView I used this :

Cursor1 = SQL1.ExecQuery2("SELECT * FROM Vestiti WHERE Categoria = ? ORDER BY rowid DESC", Array As String("T-shirts"))
For i=0 To Cursor1.RowCount-1
    
        Cursor1.Position=i
        
        Dim Buffer() As Byte
        Buffer = Cursor1.GetBlob("Immagine")
        Dim InputStream1 As InputStream
        InputStream1.InitializeFromBytesArray(Buffer, 0, Buffer.Length)
        Dim Bitmap1 As Bitmap
        Bitmap1.Initialize2(InputStream1)
        InputStream1.Close
        
        ListView1.AddTwoLinesAndBitmap(Cursor1.GetString("Identificativo"),"",Bitmap1)
        
        Next

 

[mangojack]

I tried to connect through the Sql Database Cursor.Getstring but without success

You encountered an Error ? ... What was the error message? ... How is this problem related to CustomGridView ?

Cursor1.GetString("Identificativo") result was empty ? ... We need more information.


On a side note ... better to use ResultSet (And xCustomListView instead of ListView)

Dim rs As ResultSet = SQL1.ExecQuery2("SELECT * FROM Vestiti WHERE Categoria = ? ORDER BY rowid DESC", Array As String("T-shirts"))
Do While rs.NextRow
    Dim Buffer() As Byte = rs.GetBlob("Immagine")
    '............

    ListView1.AddTwoLinesAndBitmap(rs.GetString("Identificativo"),"",Bitmap1)
Loop

 

[Matteo Granatiero]

You encountered an Error ? ... What was the error message? ... How is this problem related to CustomGridView ?

Cursor1.GetString("Identificativo") result was empty ? ... We need more information.


On a side note ... better to use ResultSet (And xCustomListView instead of ListView)

Dim rs As ResultSet = SQL1.ExecQuery2("SELECT * FROM Vestiti WHERE Categoria = ? ORDER BY rowid DESC", Array As String("T-shirts"))
Do While rs.NextRow
    Dim Buffer() As Byte = rs.GetBlob("Immagine")
    '............

    ListView1.AddTwoLinesAndBitmap(rs.GetString("Identificativo"),"",Bitmap1)
Loop

the error is that the grid.add only accepts URLs and I should load a Bitmap taken from the SQL Blob

 

[mangojack]

Maybe try this ..

B4XTable - Photos Album

In this example the table is used to show the camera roll photos. Main steps: 1. Get permission to access the external storage. 2. Collect the image files from several folders. 3. Add the columns and add ImageViews to all cells. 4. Load the images when the table is updated. 5. Show a dialog...

www.b4x.com

Or this ...

[Library] B4aGridView v3.80

Hi guys, B4AGridView is updated to v3.70. 1: GridView Demo 1: Library 1: PDF Explanations A big thanks goes to ( Sergey Tarasevich - author of Universal Image...

www.b4x.com

 

[LucaMs]

... or this:
https://www.b4x.com/android/forum/threads/grid-class-preoptimizedclv.116309/post-726808