hi
I want autocompletetex tview in android here we are using sqlite database with query using cursor.
The above code is retrieve data from data base and assign to item, i.e item is string, but its not working
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