Parse all values from Sqlite column to string Array

Question

Hi i am new in Android Sqlite Database. I want to parse all my values from a Sqlite column to an Array. It look's like folllowing:

id        name
1         Peter
2         Mary
3         Tom
4         Elsa

Android Array:

String[] NameArray = new String[4];
Int[] idArray = new Int[4];

Show us your efforts! What've you tried already?

Paweł Tomkiel
– Paweł Tomkiel

2015-03-19 10:30:23 +00:00
Commented Mar 19, 2015 at 10:30 — Paweł Tomkiel
– Paweł Tomkiel, Commented Mar 19, 2015 at 10:30

Rince Thomas · Accepted Answer · 2015-03-19 10:41:39Z

2

            String Table_Name="name of table";
            String selectQuery = "SELECT  * FROM " + Table_Name;
            SQLiteDatabase db = this.getReadableDatabase();
            Cursor cursor = db.rawQuery(selectQuery, null);
            cursor.moveToFirst();
            String[] NameArray = new String[cursor.count()];
            String[] idArray = new String[cursor.count()];
            int i = 0;

            while(cursor.moveToNext()){

                String uname = cursor.getString(cursor.getColumnIndex("name"));
                NameArray [i] = uname;
                String id= cursor.getString(cursor.getColumnIndex("id"));
                idArray [i] = id;
                i++;

            }
            db.close();

answered Mar 19, 2015 at 10:41

Rince Thomas

4,1585 gold badges27 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parse all values from Sqlite column to string Array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related