Android: Get entire column data

Question

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();

First Try Something,if you could not get the answer then share your effort and ask help. We will ready to help you. Anyhow,Try This: Run the select query and get the result in cursor.Get the cursor count and initialize the array with size cursor count. Now Iterate the cursor and put into . — Subramanian Ramsundaram
– Subramanian Ramsundaram, Commented Nov 8, 2013 at 6:27
you are not performing any loop to get all the values from table.The if statement excutes only once,so only you are getting only one name — krishna
– krishna, Commented Nov 8, 2013 at 6:57

krishna · Accepted Answer · 2013-11-08 06:27:42Z

1

 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(); }

answered Nov 8, 2013 at 6:27

krishna

4,0892 gold badges32 silver badges56 bronze badges

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

4 Comments

Sahil Lombar Over a year ago

Thanks but it doesnt work. When i run the app it says [Ljava.lang.String;@41852260

krishna Over a year ago

Ljava.lang.String;@ is returned where you used string arrays as strings.

Sahil Lombar Over a year ago

Worked wrote a loop to get the data. Thanks

Euridice01 Over a year ago

Can I get all values and not just last entry?

Collectives™ on Stack Overflow

Android: Get entire column data

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related