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.

score 3 · Answer 1 · answered Dec 16 '13 at 11:05

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 '13 at 11:05

Vaibhav Agarwal

4,499
3
19
20

score 1 · Accepted Answer · answered Dec 16 '13 at 11:05

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 '13 at 11:05

Hardik Joshi

9,477
12
61
113

score 0 · Answer 3 · answered Dec 16 '13 at 11:03

0

 myDataBase.insert(TBL_OUTTRANS, null, cv);

instead of

 myDataBase.insert(TBL_OUTTRANS, cv, null);

answered Dec 16 '13 at 11:03

Gooziec

2,736
1
13
18

Android insert multiple rows to sqlite table

3 Answers3