And So I finally experienced my listview to show result(s) from the db query, but for whatever reason its only showing 1, the final.

public class PastGames extends ListActivity {

@Override

public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    //setContentView(R.layout.pastgames);



    DBAdapter db = new DBAdapter(this);

    db.open();
    Cursor c = db.getAllFinalscores();
    if (c.moveToFirst())
    {
        do {
            String[] listData = new String [] {"Date: " + c.getString(1) + "\n" +
                    "Strokes: " + c.getString(2) + "\n" + "Holes: " + c.getString(3)};
            this.setListAdapter(new ArrayAdapter<String>(this,
                    R.layout.pastgames, listData));
        }
        while (c.moveToNext());
    }
    db.close();


}
}

dbadapter

//***RETRIEVES ALL THE FINALSCORES***//
public Cursor getAllFinalscores()
{
    return db.query(DATABASE_TABLE, new String[] {
            KEY_ROWID,
            KEY_DATE,
            KEY_FINALSCORE,
            KEY_HOLESPLAYED},
            null, null, null, null, null);
}

Could someone tell me things i am doing wrong? Why do not exhibiting each row within the db?

EDIT: Here's my xml file

<?xml version="1.0" encoding="utf-8"?>
<TextView 
    xmlns:android="http://schemas.android.com/apk/res/android"
    android:id="@id/android:list"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:textSize="16sp"
    android:padding="10dp"/>

NEW (Right way):

public class PastGames extends ListActivity {

@Override

public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    //setContentView(R.layout.pastgames);


    db.open();
    Cursor c = db.getAllFinalscores();
    String[] listData = new String[c.getCount()];
    if (c.moveToFirst())
    {
    do {

        listData[c.getPosition()] = "Date: " + c.getString(1) + "\n" +
            "Strokes: " + c.getString(2) + "\n" + "Holes: " + c.getString(3);
    }
        while (c.moveToNext());
        this.setListAdapter(new ArrayAdapter<String>(this,
            R.layout.pastgames, listData));
    }
    db.close()
}

}

For every row inside your array you're setting ListAdapter informed. This the reason why you only display the final one...

String[] listData;
do {
     listData[i] = "Date: " + c.getString(1) + "\n" +
                        "Strokes: " + c.getString(2) + "\n" + "Holes: " + c.getString(3);
   }
while (c.moveToNext());
this.setListAdapter(new ArrayAdapter<String>(this,
                        R.layout.pastgames, listData));

Fill your array shortly loop. After which call your this.setListAdapter() just once. This can solve the issue

You are reinitilizing ListData on evey loop execution