Hi,
I'm newbie on android develop....i have a question about how i implement my db columns into a listview... I do this code below but I display wich column in one row..how I display one or more columns in one row.has anyone had an reference to send me. public class Restaurants extends ListActivity { private ArrayList<RestaurantsInfo> mListRestaurants; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); try { setContentView(R.layout.restaurants); mListRestaurants = getRestaurants(); List<String> items = new ArrayList<String>(); for(RestaurantsInfo restaurant:mListRestaurants){ items.add(restaurant.res_name); items.add(restaurant.res_city); } //display into a restaurant_row.xml ArrayAdapter<String> adapter = new ArrayAdapter<String>(this, R.layout.restaurant_row,items); setListAdapter(adapter); } catch (Exception e) { // TODO: handle exception Log.e("oncreate resta",e.getMessage()); } } public ArrayList<RestaurantsInfo> getRestaurants(){ String query = "Select * from restaurants"; ArrayList<RestaurantsInfo> lstRestaurants = new ArrayList<RestaurantsInfo>(); DBAdapter dbAdapter = DBAdapter.getDBAdapterInstance(this); try { dbAdapter.createDataBase(); } catch (IOException e) { // TODO: handle exception Log.e("*** select ",e.getMessage()); } dbAdapter.openDataBase(); ArrayList<ArrayList<String>> stringList = dbAdapter.selectRecordsFromDBList(query, null); dbAdapter.close(); for (int i = 0; i < stringList.size(); i++) { ArrayList<String> list = stringList.get(i); RestaurantsInfo restaurant = new RestaurantsInfo(); try { restaurant.res_id = Integer.parseInt(list.get(0)); restaurant.res_name = list.get(1); restaurant.res_address = list.get(2); restaurant.res_number = list.get(3); restaurant.res_neiborhood = list.get(4); restaurant.res_image = list.get(5); restaurant.res_lat = list.get(6); restaurant.res_long = list.get(7); restaurant.res_city = list.get(8); } catch (Exception e) { Log.i("***" + Restaurants.class.toString(), e.getMessage()); } lstRestaurants.add(restaurant); } return lstRestaurants; } } // restaurant_row.xml <?xml version="1.0" encoding="utf-8"?> <TextView android:id="@+id/text1" xmlns:android="http:// schemas.android.com/apk/res/android" android:layout_width="wrap_content" android:layout_height="wrap_content"/> Thanks very much ! Igor Nesralla Ribeiro -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en