autocompletetextview in android using cursor for select query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bala venkata siva ram kum
    New Member
    • May 2010
    • 15

    autocompletetextview in android using cursor for select query

    hi

    I want autocompletetex tview in android here we are using sqlite database with query using cursor.

    Code:
    public void cal()
    {
    	SQLiteDatabase db= null;
    	String TableName = "enquiryhead";
    	db = openOrCreateDatabase("DatabaseName", SQLiteDatabase.CREATE_IF_NECESSARY, null);
    	db.setVersion(1);
        db.setLocale(Locale.getDefault());
        db.setLockingEnabled(true);
    	Cursor c = db.rawQuery("SELECT splr_nm FROM " + TableName , null);
    	int Column1=c.getColumnIndex("splr_nm");
    //Check if our result was valid.
        //Data=Data+"OrderNo  | Date  |  SuppierName"+"\n";
    	int k=0;
        c.moveToFirst(); 
        if (c != null)
        { 
         // Loop through all Results
        	item = new String[Column1];
         do { 
       	  String sname=c.getString(Column1);
           	item[k]=sname;
          	k++;                
                }while(c.moveToNext());
        }

    The above code is retrieve data from data base and assign to item, i.e item is string, but its not working
Working...