Android Question Help needed on list or excel

[bbfit]

Hi experts,
I'm trying to create a app that can show me price of things i search.
i have created the interface with login password, but i'm stuck at how to create a list.

eg.
house = $50
car = $100
games = $25

a app that i search for "house" in textbox, then btn_click, label will display $50.

Please advise what code is best to use to store my list.
Sorry, i'm still learning and new to B4A programming.
Do not know if use excel will be a better way too.

Thank you

 

[Mahares]

Do not know if use excel will be a better way too.

Use a map. Here is a complete project for you as a beginner that does what you want to get started, but you have to read about map and see videos. You can paste this in a project and see how it works for now, very simple to give you an idea:

Sub Globals
    Private btn As Button
    Private edt As EditText
    Private lbl As Label
    Private mp As Map
End Sub

Sub Activity_Create(FirstTime As Boolean)
    mp.Initialize
    mp.Put("house", 50)
    mp.Put("car", 100)
    mp.Put("games", 25)  'then you can store the map into a file and retrieve the map when you want to
    
    edt.Initialize("edt")
    Activity.AddView(edt, 0,0, 200dip, 75dip)
    edt.Hint="Enter object here"
    
    lbl.Initialize("lbl")
    Activity.AddView(lbl,300dip,0,150dip,75dip)  'via code, but you can do it via designer
    lbl.Color=Colors.Blue

    btn.Initialize("btn")
    Activity.AddView(btn,200dip,300dip, 150dip, 100dip)
    btn.Text="Click me"
    btn.Color=Colors.Red
End Sub

Sub btn_Click
    lbl.Text="$" & mp.Get(edt.Text)
End Sub]/code]

 

[KMatle]

Better: A map for every item. Put the maps to a list. This is compatible when you retrieve data from a database (Json)

 

[bbfit]

Use a map. Here is a complete project for you as a beginner that does what you want to get started, but you have to read about map and see videos. You can paste this in a project and see how it works for now, very simple to give you an idea:

Sub Globals
    Private btn As Button
    Private edt As EditText
    Private lbl As Label
    Private mp As Map
End Sub

Sub Activity_Create(FirstTime As Boolean)
    mp.Initialize
    mp.Put("house", 50)
    mp.Put("car", 100)
    mp.Put("games", 25)  'then you can store the map into a file and retrieve the map when you want to
  
    edt.Initialize("edt")
    Activity.AddView(edt, 0,0, 200dip, 75dip)
    edt.Hint="Enter object here"
  
    lbl.Initialize("lbl")
    Activity.AddView(lbl,300dip,0,150dip,75dip)  'via code, but you can do it via designer
    lbl.Color=Colors.Blue

    btn.Initialize("btn")
    Activity.AddView(btn,200dip,300dip, 150dip, 100dip)
    btn.Text="Click me"
    btn.Color=Colors.Red
End Sub

Sub btn_Click
    lbl.Text="$" & mp.Get(edt.Text)
End Sub]/code]

How do i store the map into a file? And code to read out the dir and filename to get the data ?
Thank you

 

[bbfit]

Better: A map for every item. Put the maps to a list. This is compatible when you retrieve data from a database (Json)

A database do you mean a xls file?

 

[Mahares]

How do i store the map into a file? And code to read out the dir and filename to get the data ?

See this link for how to read a map from a file and how to save a map to a file:

B4A - Files (Core)

www.b4x.com

Search in the forum for more information. There is a ton of valuable info. See also klaus's booklets. The link to the booklets are in @klaus signature. See also videos by Erel. Links in his signature.

 

[bbfit]

Dear all,
I got it, my code is running fine now reading from a txt file!!!!
Thank you all for the reply and guidance.