SimpleCursorAdapter Problem (nothing on the display)

EricJason · by **EricJason** » Sat Jan 08, 2011 6:17 am

Hello.
Can anybody help me with the SimpleCursorAdapter. I have a database with two columns "names" and "age".
All names should be displayed like a list. But nothing happens. It is just empty. How can I display the names on the screen?

This is my Java:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

 private void fillData() {
        // Get all of the rows from the database and create the item list
        myTeaCursor = myDBHelper.callUpAllTeas();
        startManagingCursor(myTeaCursor);
       
        // Create an array to specify the fields we want to display in the list (only NAME)
        String[] from = new String[]{TeaDB.KEY_NAME};
        
        // and an array of the fields we want to bind those fields to (in this case just text1)
        int[] to = new int[]{R.id.list};
        
        ListAdapter test = new SimpleCursorAdapter(this, R.layout.main, myTeaCursor, from, to);
        setListAdapter(test);
    }
 
Parsed in 0.032 seconds,  using GeSHi 1.0.8.4

This is my XML:

Syntax: [ Download ] [ Hide ]

Using xml Syntax Highlighting

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout 
                android:id="@+id/background1"
                android:orientation="vertical"
        android:layout_width="fill_parent"
        android:layout_height="fill_parent"
        xmlns:android="http://schemas.android.com/apk/res/android">
 
        <LinearLayout 
                android:id="@+id/background2"
                android:orientation="vertical"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        xmlns:android="http://schemas.android.com/apk/res/android">
         <TextView 
                android:id="@+id/list"
            android:layout_width="fill_parent"
            android:layout_height="wrap_content"
            android:layout_weight="1">
         </TextView>
          <ListView 
                android:id="@android:id/list"
            android:layout_width="fill_parent"
            android:layout_height="wrap_content"
            android:layout_weight="1">
         </ListView>  
        </LinearLayout>
</LinearLayout>
Parsed in 0.004 seconds,  using GeSHi 1.0.8.4

The method "callUpAllTeas" looks like this:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

public Cursor callUpAllTeas() {
        return myDb.query(DATABASE_TABLE, new String[] {
                KEY_ROWID, KEY_NAME, KEY_BREWTIME}, null, null, null, null, null);
    }
Parsed in 0.031 seconds,  using GeSHi 1.0.8.4

jiqqaman · by **jiqqaman** » Tue Jan 11, 2011 9:36 am

Hi, Im new to android development, try changing the following:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

ListAdapter test = new SimpleCursorAdapter(this, R.layout.main, myTeaCursor, from, to);
        setListAdapter(test);
 
Parsed in 0.033 seconds,  using GeSHi 1.0.8.4

to:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

SimpleCursorAdapter test = new SimpleCursorAdapter(this, R.layout.main, myTeaCursor, from, to);
        setListAdapter(test);
 
Parsed in 0.035 seconds,  using GeSHi 1.0.8.4

the main change here is using SimpleCursorAdater while you were using ListAdapter. Hope it works!

SimpleCursorAdapter Problem (nothing on the display)

SimpleCursorAdapter Problem (nothing on the display)

Re: SimpleCursorAdapter Problem (nothing on the display)

Who is online