how to fill AutoCompleteTextView from SQLite Database

Question

I am trying to design a application for android in which, I have stored all the contacts of the phone in SQLite database and i want that the suggestion in AutoCompleteTextView should be filled from the database. Please tell me how can i achieve my target?

score 2 · Accepted Answer · answered Nov 19 '12 at 06:58

2

Get an instance of CursorAdapter, then set it as the adapter of your AutoCompleteTextView.

answered Nov 19 '12 at 06:58

cycDroid

915
10
16

score 2 · Answer 2 · answered Nov 19 '12 at 07:01

2

use this to bind array to AutoCompleteTextView..you first get the values from sqlitedatabase and store in to String Array..

myAutoComplete.setAdapter(new ArrayAdapter<String>(this, android.R.layout.simple_dropdown_item_1line, item));

answered Nov 19 '12 at 07:01

Mehul Ranpara

4,245
2
26
39

score 1 · Answer 3 · answered Nov 19 '12 at 09:28

1

You just have to bind your array of data which you are getting from the database to autocomplete like this-

AutoCompletetext.setAdapter(new ArrayAdapter<String>(this, android.R.layout.simple_dropdown_item_1line, data));

answered Nov 19 '12 at 09:28

Ravi

2,277
3
22
37

how to fill AutoCompleteTextView from SQLite Database

3 Answers3