Sub Process_Globals
Private xui as XUI
Type itemvalue ( lblcode As Label, lblstyle As Label, lblgsm As Label ,btnedit As Button, btndelete As Button)
End Sub
Private Sub CreateItem (Code As String, GSM As String, Style As String, iv As itemvalue) As B4XView
Dim p As Panel = xui.CreatePanel("")
p.SetLayoutAnimated(0,0,0,100%x, 215dip)
iv.Initialize
iv.lblcode = lblccode
iv.lblgsm = lblgsm
iv.lblstyle = lblstyle
iv.btndelete = btndelete
iv.btnedit = btnedit
p.LoadLayout("Items")
lblcode.text = FabricCode
lblgsmt.Text = GSM
lblstyle.Text = Style
Return p
End Sub
Sub ShowDB
CustomListView1.Clear
Dim iv As itemvalue
Connection.myCUR = Connection.mySQL.ExecQuery("SELECT * from Customer")
If Connection.myCUR.RowCount > 0 Then
For i = 0 To Connection.myCUR.RowCount - 1
Connection.myCUR.Position = i
CustomListView1.Add(CreateItem(Connection.myCUR.GetString("Code"),Connection.myCUR.GetString("GSM"),Connection.myCUR.GetString("Style"),iv),iv)
Next
End If
End Sub