i want to get data from sqlite and display in multicolumn listview i don't have much idea of using listview i used following code but i'm getting exception that "coulmn '_id' does not exist", although i have not use _id anywhere in my whole code. Please guide me what is the problem.
public class PlanningList_activity extends Activity{
Db_sqlite dbHelper ;
private SimpleCursorAdapter dataAdapter;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.planning_list);
dbHelper = new Db_sqlite(PlanningList_activity.this);
displayListView();
}
private void displayListView() {
Cursor cursor = dbHelper.fetchPlanningData();
// The desired columns to be bound
String[] columns = new String[] {
dbHelper.CONTACTS_COLUMN_PLAN_NO,
dbHelper.CONTACTS_COLUMN_PLAN_DATE,
dbHelper.CONTACTS_COLUMN_MON,
dbHelper.CONTACTS_COLUMN_dr_code,
dbHelper.CONTACTS_COLUMN_MORN_EVEN,
dbHelper.CONTACTS_COLUMN_ff_code,
};
int[] to = new int[] {
R.id.Plan_no,
R.id.plan_date,
R.id.mon,
R.id.doc_code,
R.id.morn_even,
R.id.ff_code,
};
dataAdapter = new SimpleCursorAdapter(
this, (R.layout.single_lv_item),cursor,columns,to,0);
ListView listView = (ListView) findViewById(R.id.listView1);
listView.setAdapter(dataAdapter);
}
method for fetching values from database
public Cursor fetchPlanningData() {
SQLiteDatabase db = getReadableDatabase();
Cursor mCursor = db.query(DOC_PLANNING_TABLE_NAME, new String[] {COLUMN_PLAN_NO,COLUMN_PLAN_DATE,COLUMN_MON,COLUMN_dr_code,COLUMN_MORN_EVEN,COLUMN_ff_code},
null, null, null, null, null,null);
if (mCursor != null) {
mCursor.moveToFirst();
}
return mCursor;
}
Aucun commentaire:
Enregistrer un commentaire