vendredi 1 avril 2016

Cannot retrive spinner values from sqlite database

I have used a database class,datamodel class and main activity in my application.I am not populating spinner values from sqlite database but I am storing selected spinner values in db.I have a text entry too.I declared datamodel object separately. StudentModel student=new StudentModel(); I have used this is at two diff places.The first one inside Onclick(text)

if(v == findViewById(R.id.add)){
        tv.setText("");
        student.name = name.getText().toString();
        }

The next inside OnItemSelected(Spinner)

student.subject=subject.getItemAtPosition(position).toString();

And in the databasehelper class I retrieve them like

if (c.moveToFirst()) {
        do {

            StudentModel students = new StudentModel();
            students.id = c.getInt(c.getColumnIndexOrThrow(KEY_ID));
            students.name = c.getString(c.getColumnIndexOrThrow(KEY_NAME));
            students.subject = c.getString(c.getColumnIndexOrThrow(KEY_SUBJECT));
            studentsArrayList.add(students);
        } while (c.moveToNext());
    }

I get java.lang.IllegalArgumentException: column 'subject' does not exist while running.What am I doing wrong.I am a beginner in android app development.So forgive me for my stupididty.

Aucun commentaire:

Enregistrer un commentaire