One Column to Array SQLite

Question

can someone tell me how to change a column to an array ???

Im Making a Database and want view one of my column in android.

I have 6 column, but i just want one column from them to be an array for my listview.

Here is my table :

static final String KEY_ROWID = "_id";
static final String KEY_A = "a";
static final String KEY_B = "b";
static final String KEY_C = "c";
static final String KEY_D = "d";
static final String KEY_E = "e";

My goal is to make the "a" column to an array like this :

String arraylist[] = { "a" column data };

how can i get that ????

Query usually returns a Cursor. If you use a CursorAdapter (like SimpleCursorAdapter, or even your own subclass of it), you don't have to convert to an array/list. Would that work for you for this problem? — Karakuri
– Karakuri, Commented Jul 25, 2013 at 5:08

Peter Birdsall · Accepted Answer · 2013-07-28 23:57:36Z

1

It sounds like you should be using the cursor adapter, but if you have a good reason to use the array here's the gist of how I'd do it.

String arraylistA[];
...
yourCursor.moveToNext();
i = 0;

...
arraylistA[i] = { (yourCursor.getString(yourCursor.getColumnIndex(YourDBHelper.yourcolumnnameA))};
i + 1;
                                            or
arraylistA[i] = { (yourCursor.getString(yourCursor.getColumnIndex("yourcolumnnameA"))};
i + 1;

And then you loop thru the moveToNext and the valuation of the arraylistA. You will obviously have to define your other lists and a better loop.

answered Jul 28, 2013 at 23:57

Peter Birdsall

3,4555 gold badges34 silver badges48 bronze badges

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

1 Comment

Peter Birdsall Over a year ago

Hope it work for you, if you have more issues please contact me.

Collectives™ on Stack Overflow

One Column to Array SQLite

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related