Android Question sqllite load all value into list

[arsalan945]

In sqllite how to load all column value into list

Example
id___Name___P.Code
1___Howard__24
2___Roberts__64
3___Jack______74
4___Edwards__64
5___Daniel___ 33

Output
Log(Name) 'All Name In Column

Howard
Roberts
Jack
Edwards
Daniel

Thanks.

 

[Erel]

Check DBUtils.ExecuteMemoryTable

Or:

Dim rs As ResultSet = sql.ExecQuery("SELECT name FROM table1")
Do While rs.NextRow
 Log(rs.GetString("name"))
Next
rs.Close