Private Sub FillCLV
clvPersone.Clear
Dim RS As ResultSet
RS = mDB.ExecQuery("SELECT * FROM persone")
Dim Nome, Cognome, Professione As String
Dim id As Int
Do While RS.NextRow
Nome = RS.GetString("nome")
Cognome = RS.GetString("cognome")
Professione = RS.GetString("professione")
id = RS.GetInt("id")
clvPersone.Add(CreateItem(Nome, Cognome, Professione, id), "")
Loop
RS.Close
End Sub
Private Sub CreateItem(Nome As String, Cognome As String, Professione As String, id As Int) As B4XView
Dim pnlItem As B4XView
pnlItem = xui.CreatePanel("Item")
pnlItem.SetLayoutAnimated(0, 0, 0, clvPersone.AsView.Width, 50dip)
pnlItem.LoadLayout("layItem")
lblNome.Text = Nome
lblNome.Tag = id
lblCognome.Text = Cognome
lblProfessione.Text = Professione
Return pnlItem
End Sub
Private Sub ItemLabel_Click
Dim ItemIndex As Int
ItemIndex = clvPersone.GetItemFromView(Sender)
Dim pnlItem As B4XView
pnlItem = clvPersone.GetPanel(ItemIndex)
Dim Nome As String = pnlItem.GetView(0).Text
Dim Cognome As String = pnlItem.GetView(1).Text
Dim Professione As String = pnlItem.GetView(2).Text
Log("Nome: " & Nome)
Log("id: " & pnlItem.GetView(0).tag)
Log("Cognome: " & Cognome)
Log("Professione: " & Professione)
Log("--------------------")
End Sub