Retrieving elements from database to listview failed
My program contains an activity class and a database class.the code i used
to save the database values to listview has some problems pls help me. the
following is an innerclass in activity
class getclicker extends ListActivity implements Button.OnClickListener {
public void onClick(View v) {
String datevalue = date.getText().toString();
String Userselectvalue = userSelection.getText().toString();
cursor1 = eventsData.getContact(datevalue,Userselectvalue);
String[] fromColumns = {classdbOpenHelper.KEY_EVENT};
int[] toViews = {R.id.event};
SimpleCursorAdapter adapter = new
SimpleCursorAdapter(this,R.layout.events, cursor1,
fromColumns, toViews,0 );
listView = getListView();
listView.setAdapter(adapter);
sqlite class contains
public Cursor getContact(String datevalue, String Userselectvalue){
String selection = classdbOpenHelper.KEY_DESC + " = '" +
Userselectvalue + "'" + " AND " + classdbOpenHelper.KEY_DATE + " =
'" + datevalue+ "'";
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.query(classdbOpenHelper.DATABASE_TABLE,
new String[] {classdbOpenHelper.KEY_ROWID
,classdbOpenHelper.KEY_DESC,classdbOpenHelper.KEY_EVENT,classdbOpenHelper.KEY_DATE},
selection,
null, null, null, null);
if (cursor != null) {
cursor.moveToFirst();
}
return cursor;
}
}
public void onDestroy() {
eventsData.close();
}
}
No comments:
Post a Comment