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