Android Question SD_SQL result into a list

[jimseng]

Hello. Coming from a limited understanding of B4A I am trying to work out how to do something similar to binding MYSQL data to a combo box (or simply a datatable) that I can do in .net. So in .net I can bind a combobox to a datatable and access the rows by the combobox selected index. In B4A how can I store the results of a query, populate a combo box with a particular column name and then access the data by index. I hope you understand my question.
So if a row result contains these columns:
ID,Name,Gender.
I would like to populate a B4xComboBox with the "Name" column and then later access the "Gender" column data based on the ComboBox index. Do I use a map? a list? I am a bit unsure how to go about this.
Thanks

 

[epiCode]

you can check out this example. it uses xclv instead of combo box but you will get the understanding of how a value is displayed and its related value is accessed.

[B4X][B4XPages] SQL + xCLV Example

A simple, cross platform example that reads data from a database and adds it to a xCLV. Database source: https://www.sqlitetutorial.net/sqlite-sample-database/ The interesting code: Private Sub B4XPage_Created (Root1 As B4XView) Root = Root1 Root.LoadLayout("MainPage")...

www.b4x.com