public String[] retrieveVendorNameList(Context context) { db = getDatabase(context); Cursor cursor = salesDB.retrieveHeaderList(db); ArrayList<String> mVendorNameList = new ArrayList<String>(); while (cursor.moveToNext()) { String vendorName = cursor.getString(1); mVendorNameList.add(vendorName); } cursor.close(); db.close(); String[] strVendorNameList = new String[mVendorNameList.size()]; for (int i = 0; i < mVendorNameList.size(); i++) { strVendorNameList[i] = mVendorNameList.get(i); } return strVendorNameList; }
public ArrayList<Header> retrieveHeaderList(Context context) { db = getDatabase(context); Cursor cursor = salesDB.retrieveHeaderList(db); ArrayList<Header> mHeaderList = new ArrayList<Header>(); while (cursor.moveToNext()) { Header header = new Header( cursor.getString(0), cursor.getString(1), cursor.getString(2), cursor.getString(3), cursor.getString(4), cursor.getString(5)); mHeaderList.add(header); } cursor.close(); db.close(); return mHeaderList; }