Android insert multiple rows to sqlite table

Question

Hello everybody I would like to insert multiple records to my sqlite table at once,

This is what I've tried:

DBHelper.class

   public void insertToOUTTRANS(ArrayList<String> arrListDocumentNumber){
            ContentValues cv = new ContentValues();

            for(String text : arrListDocumentNumber){
                cv.put(KEY_DOCUMENTNUMBER, text);
            }
            myDataBase.insert(TBL_OUTTRANS, cv, null);
        }

But I'm getting error in this line:

  myDataBase.insert(TBL_OUTTRANS, cv, null);

Error says:

 The method insert(String, String, ContentValues) in the type SQLiteDatabase is not applicable for the arguments (String, ContentValues, null)

MainActivity.class:

  for(int i = 0; i< arrDocumentNumber.length; i++) {
    ArrayList<String> arrListDocumentNumber = new ArrayList<String>();
    ArrayList<String> arrListUnitOfMeasure = new ArrayList<String>();
    ArrayList<String> arrListLocationCode = new ArrayList<String>();

            arrListDocumentNumber.put(tvItemCode.getText().toString());
            arrListUnitOfMeasure.put(editText1.getText().toString));
            arrListLocationCode.put(editText1.getText().toString));

   }

But I'm kinda confused how to loop over the cursor to check for all items from the listview to save to my table. Any ideas? I would gladly appreciate your help. Thanks.

Vaibhav Agarwal · Accepted Answer · 2013-12-16 11:05:51Z

3

Try this

for(int i=0;i<arrListDocumentNumber.size();i++)
{
    ContentValues initialValues=new ContentValues();
    initialValues.put(KEY_DOCUMENTNUMBER, arrListDocumentNumber.get(i));
    db.insert(TBL_OUTTRANS, null, initialValues);
}

answered Dec 16, 2013 at 11:05

Vaibhav Agarwal

4,4973 gold badges21 silver badges20 bronze badges

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

Comments

Hardik Joshi · Accepted Answer · 2013-12-16 11:05:18Z

1

The insert methods looks like..

insert(String, String, ContentValues)

So you need to pass arguments like..

myDataBase.insert(TBL_OUTTRANS, null, cv);

Check syntax here.

answered Dec 16, 2013 at 11:05

Hardik Joshi

9,50712 gold badges66 silver badges117 bronze badges

Comments

Gooziec · Accepted Answer · 2013-12-16 11:03:11Z

0

 myDataBase.insert(TBL_OUTTRANS, null, cv);

instead of

 myDataBase.insert(TBL_OUTTRANS, cv, null);

answered Dec 16, 2013 at 11:03

Gooziec

2,7761 gold badge15 silver badges18 bronze badges

Collectives™ on Stack Overflow

Android insert multiple rows to sqlite table

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related