Begginner working with ListAdapters / SQLite Database
<p>My programming knowledge is slim, i discovered Java and the Android SDK some days ago.</p>

<p>I have a SQLiteDatabase, a SQLiteOpenHelper, and a Cursor working properly
( means i think i understood how to create/open a DB using a SQLiteOpenHelper, make queries on my DB and get a cursor )</p>

<p>currently, i'm wrapping i + labName + labCity into a single results String, and display into a single TextView R.id.label</p>

<p>Is it possible to bind labName to R.id.label, and bind labCity to another TextView R.id.label2 ?</p>

<p>Here is the code of my ListActivity i need help with :</p>

<pre><code>public class MainLabList extends ListActivity implements OnItemClickListener {

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.main_lab_list);

    // DB
    GestionDB gdb = new GestionDB(this, GestionDB.DATABASE_NAME, null, GestionDB.DATABASE_VERSION);
    SQLiteDatabase theDB = gdb.getWritableDatabase();

    // Cursor
    String[] columns = {GestionDB.LAB_NAME, GestionDB.LAB_ADDRESS_CITY};
    Cursor c =
        theDB.query(GestionDB.TABLE_NAME, columns, null, null, null, null, null);

    ////////
    this.setTitle(" " + c.getCount() + " Labs in Local Database");
    ArrayList&lt;String&gt; results = new ArrayList&lt;String&gt;();
    int i = 0; 
    c.moveToFirst();

    /* Loop through all Results */ 
    do { 
         i++;         
         String labName = c.getString(c.getColumnIndex(GestionDB.LAB_NAME));
         String labCity = c.getString(c.getColumnIndex(GestionDB.LAB_ADDRESS_CITY)); 

         /* Add current Entry to results. */ 
         results.add("" + i + ": " + labName 
                        + " (" + labCity +  ")"); 
    } while (c.moveToNext());

    //need rework               
    ListView lvLabListing = (ListView) findViewById(android.R.id.list);
    ArrayAdapter&lt;String&gt; labListAdapter = new ArrayAdapter&lt;String&gt;(this,
            R.layout.listing, R.id.label, results );
    lvLabListing.setAdapter(labListAdapter);
    lvLabListing.setOnItemClickListener(this);
    //

    // don't forget to close the database
    gdb.close();
</code></pre>

<p>And the listing.xml i would like to modify :</p>

<pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
&lt;LinearLayout
  xmlns:android="http://schemas.android.com/apk/res/android"
  android:layout_height="wrap_content" android:layout_width="fill_parent"&gt;
&lt;ImageView android:id="@+id/ImageView01" android:layout_width="wrap_content" android:layout_height="wrap_content" android:src="@drawable/icon"&gt;&lt;/ImageView&gt;
&lt;TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:id="@+id/label"&gt;&lt;/TextView&gt;
&lt;/LinearLayout&gt;
</code></pre>

<p>My GestionDB class is simple, just define some columns if the database doesn't exist, along with some variables.</p>
