Error in Implementing SimpleCursorAdapter

Question

I am having the code as shown below. Load.java

public class Load extends AppCompatActivity {

ListView list;
MydbHelper db;
SimpleCursorAdapter adapter;
@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_load);
    db= new MydbHelper(getApplicationContext());
    list = findViewById(R.id.lv1);
    String[] arrayCols = new String[]{"_id","NAME","PHONE"};
    int[] arrayIDs = new int[]{0,R.id.tv1,R.id.tv2};
    Cursor data = db.getdata();
    if (data.getCount()==0){
        Toast.makeText(this, "No data to print in the list", Toast.LENGTH_SHORT).show();
    }
    else{
        do{
            //adapter = new NewAdapter(getApplicationContext(),R.layout.mylist,data,0);
            adapter= new SimpleCursorAdapter(this, R.layout.mylist,data,arrayCols,arrayIDs,0);
            list.setAdapter(adapter);
            Toast.makeText(this,"list is running",Toast.LENGTH_LONG).show();
        }while (data.moveToNext());
    }

}

}

Class MydbHelper.java

  public class MydbHelper extends SQLiteOpenHelper {
Context mycontext;
public MydbHelper(Context context) {
    super(context, "MyDB", null, 1);
    this.mycontext=context;
}

@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
    sqLiteDatabase.execSQL("CREATE TABLE BHASKAR(_id INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT, PHONE INT);");
    sqLiteDatabase.execSQL("INSERT INTO BHASKAR VALUES(1,'RAHUL',9127543008)");
}

@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

}
public Cursor getdata(){
    SQLiteDatabase database = getReadableDatabase();

    Cursor data = database.rawQuery("SELECT * FROM BHASKAR",null);
    return data;
}

} It encountered an error as follows:

Error in the Logcat:Screenshot of Logcat

Caused by: java.lang.IllegalArgumentException: column '_id' does not exist at android.database.AbstractCursor.getColumnIndexOrThrow(AbstractCursor.java:303) at android.widget.CursorAdapter.init(CursorAdapter.java:172) at android.widget.CursorAdapter.(CursorAdapter.java:149) at android.widget.ResourceCursorAdapter.(ResourceCursorAdapter.java:91) at android.widget.SimpleCursorAdapter.(SimpleCursorAdapter.java:104)

Please do help me. at in.complit.csync.Load.onCreate(Load.java:31)

Error inImplementing SimpleCursorAdapter What error??

AskNilesh
– AskNilesh

2018-06-18 06:35:23 +00:00
Commented Jun 18, 2018 at 6:35 — AskNilesh
– AskNilesh, Commented Jun 18, 2018 at 6:35

Mitesh Sawant · Accepted Answer · 2018-06-22 07:44:44Z

//MyHelper.java

public class MyHelper extends SQLiteOpenHelper {

    public MyHelper(Context context) {
        super(context,"student",null,1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {

        db.execSQL("create table stud(rollno int primary key,name TEXT,phone long);");
        db.execSQL("insert into stud values(1,'bca',9988998899);");
        db.execSQL("insert into stud values(2,'mca',9988998897);");

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}

//MainActivity.java

public class MainActivity extends AppCompatActivity {

    MyHelper mh;
    SQLiteDatabase db;
    Cursor rs;
    ListView lv;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        MyHelper mh = new MyHelper(getApplicationContext());
        db = mh.getReadableDatabase();

        lv = (ListView) findViewById(R.id.mylist);

        rs = db.rawQuery("select rollno _id,name,phone from stud",null);

        SimpleCursorAdapter sca = new SimpleCursorAdapter(getApplicationContext(),
                R.layout.detail_adapter,rs,new String[]{"_id","name","phone"},
                new int[]{R.id.textid,R.id.textname,R.id.textphone},0);

        lv.setAdapter(sca);
    }
}


    //activity_main.xml

       <ListView
            android:id="@+id/mylist"
            android:layout_width="match_parent"
            android:layout_height="match_parent"
            android:layout_centerVertical="true"
            android:layout_centerHorizontal="true" />

//detail_adapter.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
    android:layout_width="match_parent"
    android:layout_height="match_parent">


    <TextView
        android:text="TextView"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:id="@+id/textid" />

    <TextView
        android:text="TextView"
        android:layout_marginLeft="25dp"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:id="@+id/textname" />

    <TextView
        android:text="TextView"
        android:layout_marginLeft="25dp"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:id="@+id/textphone" />
</LinearLayout>

Reaz Masud · Accepted Answer · 2018-06-18 06:42:12Z

0

As you did not mention what exactly the error that you are getting there, I might suggest the changes that you can do in your code.

list = findViewById(R.id.lv1);
String[] arrayCols = new String[]{"NAME", "PHONE"};
int[] arrayIDs = new int[]{R.id.tv1, R.id.tv2};
Cursor data = db.getdata();

if (data.getCount() == 0) {
    Toast.makeText(this, "No data to print in the list", Toast.LENGTH_SHORT).show();

} else {

    // Move the cursor to first position
    data.moveToFirst();

    // Initialize the adapter here. 
    adapter = new SimpleCursorAdapter(this, R.layout.mylist, data, arrayCols, arrayIDs, 0);
    list.setAdapter(adapter);
}

Then loop through your data in your SimpleCursorAdapter.

answered Jun 18, 2018 at 6:42

Reaz Masud

24.3k15 gold badges83 silver badges102 bronze badges

4 Comments

Bhaskar Ranjan Over a year ago

Error in the logcat ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::Caused by: java.lang.IllegalArgumentException: column '_id' does not exist at android.database.AbstractCursor.getColumnIndexOrThrow(AbstractCursor.java:303) .....at in.complit.csync.Load.onCreate(Load.java:29) where (Load.java:29) contain the line " adapter = new SimpleCursorAdapter(this, R.layout.mylist, data, arrayCols, arrayIDs, 0); "

Reaz Masud Over a year ago

We cannot help you without the code in your adapter, i.e. SimpleCursorAdapter. And please make sure that, you have created the database as well.

Bhaskar Ranjan Over a year ago

public MydbHelper(Context context) { super(context, "MyDB", null, 1); this.mycontext=context; } public void onCreate(SQLiteDatabase sqLiteDatabase) { sqLiteDatabase.execSQL("CREATE TABLE BHASKAR(NAME TEXT, PHONE INT);"); sqLiteDatabase.execSQL("INSERT INTO BHASKAR VALUES('RAHUL',9127543008)"); }

Bhaskar Ranjan Over a year ago

done sir, please go through the code and provide a suitable solution for the specific error

Sagar · Accepted Answer · 2018-06-19 05:48:35Z

0

There is no need to loop through the data cursor using do{...}whie(...). Simply change your code as follows

list = findViewById(R.id.lv1);
String[] arrayCols = new String[]{"NAME","PHONE"};
int[] arrayIDs = new int[]{R.id.tv1,R.id.tv2};
Cursor data = db.getdata();
if (data.getCount()==0) {
    Toast.makeText(this, "No data to print in the list", Toast.LENGTH_SHORT).show();
}
else{
    adapter= new SimpleCursorAdapter(this, R.layout.mylist,data,arrayCols,arrayIDs,0);
    list.setAdapter(adapter);
    Toast.makeText(this,"list is running",Toast.LENGTH_LONG).show();           
}

Note:

Remember to add a space between the left parenthesis '(' and _id during creation. You might need to uninstall and install the app so that changes are taken place correctly.

edited Jun 19, 2018 at 5:48

answered Jun 18, 2018 at 6:38

Sagar

25k4 gold badges68 silver badges67 bronze badges

10 Comments

Reaz Masud Over a year ago

He needs to loop through the data inside SimpleCursorAdapter.

Bhaskar Ranjan Over a year ago

Caused by: java.lang.IllegalArgumentException: column '_id' does not exist....... at in.complit.csync.Load.onCreate(Load.java:29) where (Load.java:29) contains adapter= new SimpleCursorAdapter(this, R.layout.mylist,data,arrayCols,arrayIDs,0);

Sagar Over a year ago

@BhaskarRanjan does your DB has column named 'NAME' & 'PHONE' ?

Bhaskar Ranjan Over a year ago

public void onCreate(SQLiteDatabase sqLiteDatabase) { sqLiteDatabase.execSQL("CREATE TABLE BHASKAR(NAME TEXT, PHONE INT);"); sqLiteDatabase.execSQL("INSERT INTO BHASKAR VALUES('RAHUL',9127543008)"); }

Sagar Over a year ago

@BhaskarRanjan can you use String[] arrayCols = new String[]{"_id","NAME","PHONE"};

|

Collectives™ on Stack Overflow

Error in Implementing SimpleCursorAdapter

3 Answers 3

Comments

4 Comments

10 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

10 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related