Populating An Android Spinner From An Sqlite But With Two Fields?

I've finally managed to populate a spinner from an sqlite db after much messing about with this code however it's only using one field and I want First and Last names on the same s

Solution 1:

For this, you need to change the android.R.layout.simple_spinner_item and android.R.layout.simple_spinner_dropdown_item, as these layout items are able to display only one item in the dropdown list and on the spinner. For your purpose, the best way is to create your own layout that has two items. Here is a link about how to do it.