CODEWITHSUNDEEP
androidsqlite
Sahil Lombar
Sahil Lombar

Reputation: 145

Android: Get entire column data

Im trying to get the data of an entire column into a string array. My database contains two columns Id and Names. I want to read all the entries of the names column and put it into a array. Please help.

EDIT #1: Im using the following code but i can get only one name with this code.

String query = "Select * FROM " + TABLE_APPS + " WHERE " + COLUMN_NAME + " =  \"" + productname + "\"";

        SQLiteDatabase db = this.getWritableDatabase();

        Cursor cursor = db.rawQuery(query, null);

        if (cursor.moveToFirst()) {
            cursor.moveToFirst();
            name = cursor.getString(1);
            cursor.close();
        } else {
            name = null;
        }
            db.close();

Upvotes: 0

Views: 2245

Answers (1)

krishna
krishna

Reputation: 4099

    int total=0;
    Cursor csr=sdb.query("tablename", null, null,null,null,null,null);
    csr.moveToFirst();
    while(!csr.isAfterLast())
    {
        total++;
         csr.moveToNext();
    }

    String strarray[] = new String[total];

    Cursor csrs=sdb.query("tablename", null, null,null,null,null,null);
    csrs.moveToFirst();
    int aray=0;
    while(!csrs.isAfterLast())
    {
        strarray[aray]=csrs.getString(1);
        aray++;
        csrs.moveToNext();
    }

Upvotes: 1

Related Questions