Android parse value from .sqlite file

Question

How to parse value from .sqlite file, i n my sqlite file there are more than 1000 records now i need to retrieve all the values and need to show that in a listview, i have saved that file in to my asset folder, is there any way to do as like parsing csv file

All the suggestions are most welcome Thanks in advance

Community · Accepted Answer · 2017-05-23 11:43:33Z

1

You had database which has more than 1000 of records and it's in assets folder of application...

For that you need to copy asset database to installed app folder and then use it using SQLiteOpenHelper..

For more details with example you can take reference from here..

Ship an application with a database

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Feb 26, 2015 at 6:04

user4571931

Sign up to request clarification or add additional context in comments.

Comments

hidro · Accepted Answer · 2015-02-26 06:00:17Z

1

I would recommend:

Save your data into SQLite, create ContentProvider to allow querying/updating data
See: http://developer.android.com/guide/topics/providers/content-providers.html
Use CursorLoader and CursorAdapter to load data from ContentProvider and bind them to your list view asynchronously
See: https://developer.android.com/training/load-data-background/setup-loader.html

The whole process seems to be overwhelmed at first with a lot of things need to be created, but once done you will get the flow.

answered Feb 26, 2015 at 6:00

hidro

12.6k6 gold badges55 silver badges54 bronze badges

Collectives™ on Stack Overflow

Android parse value from .sqlite file

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related