How to find the exact data in sqlite database
and retrieve it in a listactivity
? I tried like this but I didn't get the value.
search = (EditText) findViewById(R.id.alertsearch);
search.addTextChangedListener(new TextWatcher(){
@Override
public void afterTextChanged(Editable s) {
// TODO Auto-generated method stub
list2.clear();
db = openOrCreateDatabase(Contactsnew.DB_NAME, MODE_PRIVATE, null);
Cursor cTitle=db.rawQuery(" SELECT * FROM "+ Contactsnew.TABLE02 + " WHERE "
+ Contactsnew.userid + " = " + GetSet.getUserId() + " AND " + Contactsnew.TITLE +
" LIKE ? " ,new String []{search.getText()+"%"});
custAdapter.changeCursor(cTitle);
while(cTitle.moveToNext()){
list2.add(cTitle.getString(2));
}
cTitle.close();
}
In your sqliteconnecter create a method and call that method from your respective class. Now type the following code in ur sqlite class.
Cursor cusror;
cursor=db.rawQuery("SELECT * FROM "+ Contactsnew.TABLE02 + " WHERE "
+ Contactsnew.userid + " = " + Contactsnew.userId + " AND " + Contactsnew.TITLE +
" LIKE '"+search.getText()+"%'");
print the query in a string and check whether you are getting the correct values, then return the cursor.
try this and say!!