Click here to Skip to main content
11,922,026 members (38,070 online)
Rate this:
Please Sign up or sign in to vote.
Hi, I'm attempting to develop an Android app and using a SQLite database to store the data, which I have stored in the Assets folder. Problem is I'm having trouble reading in and populating a ListView with this data. I have read that using LoaderManager, CursorLoader and a ContentProvider is the best way to do this. But I'm having trouble finding any clear information or tutorials on this.

Any advice on the best way to go about this would be really appreciated.

Thanks Guys
Posted 26-Feb-13 15:29pm
DalliaF 8-Mar-13 2:28am
this site may help-->
Member 9856775 9-Mar-13 10:37am
Thanks DalliaF for your help, thats a really useful site
criselda 8-Mar-13 23:36pm
create a class DataBaseHandler through which you can access database tables and retrieve the data you want. For eg, use query like "Select * from plants table" and store the data related to each row in a plant bean class. Pass the collection of beans to list adapter. And display only name by using getName method of bean class. On click, pass the corresponding bean and populate linear layout with the fields values of bean object.
Member 9856775 9-Mar-13 10:40am
Thanks Criselda, I appreciate your help. I will give it a go.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 493
1 Dave Kreskowiak 285
2 Sergey Alexandrovich Kryukov 243
3 Richard MacCutchan 155
4 ppolymorphe 135
0 OriginalGriff 7,231
1 KrunalRohit 4,530
2 Sergey Alexandrovich Kryukov 3,356
3 George Jonsson 2,865
4 Suvendu Shekhar Giri 2,216

Advertise | Privacy | Mobile
Web02 | 2.8.151120.1 | Last Updated 26 Feb 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100