get array of database info android?

Question

this is my code for getting data from database,but any things not show.what's wrong about it

public String[] GetData() {

    String[] result =new String[]{};
    int counter=0;
    String[] Columns = new String[]{KEY_ID, KEY_NAME, KEY_PHONE, KEY_EMAIL, KEY_ADDRESS};

    Cursor cr = myDB.query(DATABASE_TABLE, Columns, null, null, null, null, null);

    int ROW_NAME = cr.getColumnIndex(KEY_NAME);
    int ROW_PHONE = cr.getColumnIndex(KEY_PHONE);
    int ROW_EMAIL = cr.getColumnIndex(KEY_EMAIL);
    int ROW_ADDRESS = cr.getColumnIndex(KEY_ADDRESS);


    for (cr.moveToFirst(); !cr.isAfterLast(); cr.moveToNext()) {
       result[counter]= cr.getString(ROW_NAME) + " " + cr.getString(ROW_PHONE) + " " + cr.getString(ROW_EMAIL) + " " + cr.getString(ROW_ADDRESS)+"\n";
        counter++;
    }
    return result;
}

please help me in this code!! – amardco Oct 29 '16 at 07:16 — amardco, Oct 29 '16 at 07:16
it doesn't show anything or it crushes? – Marco Pierucci Oct 29 '16 at 07:39 — Marco Pierucci, Oct 29 '16 at 07:39

score 0 · Accepted Answer · answered Oct 29 '16 at 07:42

0

Initialize result this way:

String[] result =new String[cr.getCount()];

answered Oct 29 '16 at 07:42

Marco Pierucci

1,125
8
23

get array of database info android?

1 Answers1