public String getData() { // TODO Auto-generated method stub String[] columns = new String[]{KEY_ROWID, KEY_TYPE, KEY_MODULENAME, KEY_ASSWEIGHTING, KEY_ISSUEDATE, KEY_DUEDATE, KEY_NOTES}; //Read information from columns Cursor c = ourDatabase.query(DATABASE_TABLE, columns, null, null, null, null, null); String result = ""; int iRow = c.getColumnIndex(KEY_ROWID); int iType = c.getColumnIndex(KEY_TYPE); int iName = c.getColumnIndex(KEY_MODULENAME); int iWeighting = c.getColumnIndex(KEY_ASSWEIGHTING); int iIssue = c.getColumnIndex(KEY_ISSUEDATE); int iDue= c.getColumnIndex(KEY_DUEDATE); int iNotes = c.getColumnIndex(KEY_NOTES); //read entries until cursor is at the end of the last entry for (c.moveToFirst();!c.isAfterLast(); c.moveToNext()) { //set result to information being read result = result +c.getString(iRow) + " " + c.getString(iType) + " " + c.getString(iName) + " " + c.getString(iWeighting) + " " + c.getString(iIssue) + " " + c.getString(iDue) + " " + c.getString(iNotes) + "\n"; } return result; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)