vendredi 21 août 2015

Fetching Data from Database while typing in EditText

I'm trying to fetch data from database on each integer type and set Text to two other EditText but when I press any key App crashed

Here is my try :

    protected final TextWatcher BarCodeWatcher = new TextWatcher() {
    public void beforeTextChanged(CharSequence s, int start, int count, int after) {
    }

    public void onTextChanged(CharSequence s, int start, int before, int count) {
        Cursor cursor = mDbHelper.getTestData(s.toString());

        Log.e("Hello :",cursor.getString(cursor.getColumnIndex("Item_Name")));
        if (cursor.getCount() != 0) {

            String itemName = cursor.getString(cursor.getColumnIndex("Item_Name"));
            itemNameEdit.setText(itemName);
            String unitPrice = cursor.getString(cursor.getColumnIndex("Sale_Price"));
            unitPriceEdit.setText(unitPrice);
            cursor.close();
        }
    }

    public void afterTextChanged(Editable s) {
    }
};

**Logcat: **

Process: com.example.fani.project, PID: 29441
java.lang.NullPointerException: Attempt to invoke virtual method 'android.database.Cursor android.database.sqlite.SQLiteDatabase.rawQuery(java.lang.String, java.lang.String[])' on a null object reference

Aucun commentaire:

Enregistrer un commentaire