// Getting All Doctor public List<FamilyProfileClass> getAllFamilyProfile() { List<FamilyProfileClass> familyProfileClasses = new ArrayList<FamilyProfileClass>(); // Select All Query String selectQuery = "SELECT * FROM " + SQLiteHelper.TBL_I_CARE_FAMILY_PROFILE; iCareDatabase = iCareDbHelper.getWritableDatabase(); Cursor cursor = iCareDatabase.rawQuery(selectQuery, null); // looping through all rows and adding to list if (cursor.moveToFirst()) { do { FamilyProfileClass familyProfileClass = new FamilyProfileClass(); familyProfileClass.setFid(Long.parseLong((cursor.getString(0)))); familyProfileClass.setFname(cursor.getString(1)); familyProfileClass.setFNumber(cursor.getString(2)); familyProfileClass.setFrelationship(cursor.getString(3)); familyProfileClass.setFage(cursor.getString(4)); familyProfileClass.setFbloodGroup(cursor.getString(5)); familyProfileClass.setFheight(cursor.getString(6)); familyProfileClass.setFweight(cursor.getString(7)); familyProfileClass.setFdateOfBirth(cursor.getString(8)); familyProfileClass.setFspecialNotes(cursor.getString(9)); // Adding contact to list familyProfileClasses.add(familyProfileClass); } while (cursor.moveToNext()); } // return contact list return familyProfileClasses; }