Problem with AutoCompleteTextView and SimpleCursorAdapter

by class_java » Tue, 03 Mar 2009 06:19:52 GMT

Sponsored Links
 Hi All,

I have a AutoCompleteTextView and I wont in the drop down list that
appears while typing to contain data from a database through
SimpleCursorAdapter. The drop down list appears, but there is not text
in it. When I click in the drop down item seems to work fine, the Text
is correctly shown in the AutoCompleteTextView. Please help...

Code samples:
 final AutoCompleteTextView editTxt = (AutoCompleteTextView)

        mDbHelper = new DbHelper(this);

        Cursor cursor = mDbHelper.fetchAll();
        int[] to = new int[]{android.R.layout.select_dialog_item};
        SimpleCursorAdapter cursAdapt = new SimpleCursorAdapter
(this,android.R.layout.simple_dropdown_item_1line,cursor,new String[]
        cursAdapt.setCursorToStringConverter(new CursorConverter());

<?xml version="1.0" encoding="utf-8"?>

<TextView  xmlns:android="" ;

public class CursorConverter implements CursorToStringConverter{

        public CharSequence convertToString(Cursor cursor) {
         String a = cursor.getString(1);
         return a;


Thanks in advance...


Problem with AutoCompleteTextView and SimpleCursorAdapter

by Will » Wed, 04 Mar 2009 02:03:05 GMT

 I haven't done one of these with a SimpleCurosrAdapter, but I've
worked through it with a Cursor/CursorAdapter.  I just uploaded to the
Developers group what I think is the minimum code for an AutoComplete
with a Cursor/CursorAdapter.

It's here:  

Sponsored Links

Problem with AutoCompleteTextView and SimpleCursorAdapter

by Tseng » Wed, 04 Mar 2009 06:24:21 GMT

 ou don't have to create your own XML file if you're just want to
display a one-liner dropdown menu. Instead better to use the already
defined one in the android resources. Basically you can leave the
auto_complete.xml, as it's not used anyways in your code (unless you
want to design your own dropdown list views).

Basically there are two reasons:
1. You haven't set the color states correctly so the text color =
background color
2. You have selected a wrong id in the "to" parameters

In your example, the latter seems to be the case.

you're using an layout id as "to". This is wrong. You have to use the
ID of the textfield in which your data belongs.

For example you have to data fields in your cursor, lets say

new String[] { DbHelper.FOOD_NAME, DbHelper.FOOD_PRICE }

Now if you have an layout file, with 2 TextView elements called
foodname and foodprice, you'd have to make the "to" part as follows
new int[] {,} in exactly this order. First
element of from (DbHelper.FOOD_NAME) will be placed in the view with
the first ID from "to" (in this case:

Since you're using the predefined android layout for the dropdown list
(android.R.layout.simple_dropdown_item_1line), the (only) textview
item is called

So changing
int[] to = new int[]{android.R.layout.select_dialog_item};
SimpleCursorAdapter cursAdapt = new SimpleCursorAdapter
(this,android.R.layout.simple_dropdown_item_1line,cursor,new String[]


int[] to = new int[]{};
SimpleCursorAdapter cursAdapt = new SimpleCursorAdapter
(this,android.R.layout.simple_dropdown_item_1line,cursor,new String[]

should do the trick. You HAVE to use, because this
is the id which was set in android sdks \res\layout
\simple_dropdown_item_1line.xml file.

This is btw the case for all default android layout files. They have
no fixed names, instead it's always to or to in
case of buttons (i.e. in default Dialog layouts)

On Mar 2, 10:49pm, class_java <> wrote:

Other Threads

1. Finish sub activity Overlapping (Urgent)


I am trying to finish sub Activities but they are getting overlapping

help me out please

super.onActivityResult(requestCode, resultCode, data, extras);


2. Notification trying to be immortal - how to kill it

(I posted this on the challenge group accidentally, but this is a dev
Hi, my local service occasionally sends out notifications through the
notification manager.

Clicking on the notification launches an activity. From within the
activity, I call bindService and then call a service-api to do

This works most of the time.
However, some other times, the notification refuses to be cancelled
and stays on top of the screen.
I have trace code that confirms that the service has called cancel for
the correct id.

Does anyone know how to fix or workaround the problem ?


3. How do i schedule the alarm at boot up?

4. Cannot get Linkify.addLinks() to work

5. Running the same activity from an activity?

6. trouble with AIDL parser

7. Cursor c = this.getContentResolver().query( gets nullpointer exception when code is moved