vendredi 23 janvier 2015

get data from sqlite and display in multi column listview

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