How to insert data into particular columns dynamically into a table in android

Question

I have a table with columns : transaction_name | member1 | member2 | member3 | member4

In my activity, I will receive a String array of column names of this table, say columnarray[] = {"member1","member3","member4"}

and also I will receive a Integer array of column values to insert into those particular columns, say valuearray[] = {value1,value3,value4}

Now, in my activity, I have to write a query such that i have to insert these values(in integer array) into these columns(in string array) dynamically.

Simply, the following action should be performed :

"INSERT into tablename(member1,member3,member4) values(value1,value3,value4)"

As I will receive these column names and column values from arrays, how can i perform this insertion operation on my table dynamically?

Boris Strandjev · Accepted Answer · 2012-02-25 14:11:57Z

1

Using an ordinary SQLiteDatabase:

ContentValues values = new ContentValues();
for (int i = 0; i < columnarray.length(); i++) {
    values.put(columnarray[i], valuearray[i]);
}
database.insert("tablename", null, values);

answered Feb 25, 2012 at 14:11

Boris Strandjev

47.1k16 gold badges113 silver badges136 bronze badges

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

Collectives™ on Stack Overflow

How to insert data into particular columns dynamically into a table in android

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