mercredi 23 décembre 2015

Error in read data into Listview

This is my code. DatabaseHelper.java that get all data form SQLite

public List<String> getAllLvMenu() {
    String query = "select * from"+TABEL_LV;
    db = this.getReadableDatabase();
    Cursor c = db.rawQuery(query, null);

    final List<String> menulv = new ArrayList<String>();
    try {
        while (c.moveToNext()) {
            menulv.add(c.getString(1));
        }
    } finally {
        close();
    }
    return menulv;
}

Code of fragment_listview.java where the fetch data show it to listview.

public class LvFragment extends ListFragment {

DatabaseHelper db;

public LvFragment(){

}
@Override
public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
    ViewGroup rootView = (ViewGroup)inflater.inflate(R.layout.fragment_listview, container, false);
    List<String> menulv = db.getAllLvMenu();
    ArrayAdapter menuLV = new ArrayAdapter<String>(getContext(), R.layout.row_layout, menulv);
    setListAdapter(menuLV);
    setRetainInstance(true);

    return rootView;
}
....
}

I got error on that code. I want to read from sqlite and show it in Listview using ListFragment.

Can you help me?

Aucun commentaire:

Enregistrer un commentaire