How to view data saved in android database SQLite

Question

I am able to view the database from eclipse from file explorer   but I want to view the whole detail  I mean the data that I have inserted  which I am unable   And my complete Android installation has made on F Drive  So any help will be appreciated Thanks a lot

User · Answer

Try this     Download the Sqlite Manager jar file here  Add it to your eclipse   dropins Directory  Restart eclipse  Launch the compatible emulator or device Run your application  Go to Window   Open Perspective   DDMS   Choose the running device  Go to File Explorer tab  Select the directory called databases under your application s package  Select the  db file under the database directory  Then click Sqlite manager icon like this   Now you re able to see the  db file    Happy coding

User · Answer

Open DDMS than in DATA DATA  Select your package like com example foo   than select your database folder than pull that data  in eclipse you can see the pull an push icon on top right side

User · Answer

If you don t want to download anything  you can use sqlite3 tool which is provided with adb     Examining sqlite3 databases from a remote shell  and    Command Line Shell For SQLite

User · Answer

Dowlnoad sqlite manager and install it from Here Open the sqlite file using that browser

User · Answer

I recommend the firefox plugin SQLLite Manager  if you always use firefox   Here is the link

User · Answer

1  Download SQLite Manager 2  Go to your DDMS tab in Eclipse 3  Go to the File Explorer -- gt  data -- gt  data -- gt   Your Package Name  -- gt  pull file from device 4  Open file in SQLite Manager  5  View data

User · Answer

If you are able to copy the actual SQLite database file to your desktop  you can use this tools to browse the data

User · Answer

You can access this folder using the DDMS for your Emulator  you can t access this location on a real device unless you have a rooted device   You can view Table structure and Data in Eclipse  Here are the steps   Install SqliteManagerPlugin for Eclipse  Jump to step 5 if you already have it  Download the   jar file from here Put the   jar file into the folder eclipse dropins  Restart eclipse In the top right of eclipse  click the DDMS icon Select the proper emulator in the left panel In the File Explorer tab on the main panel  go to  data data  YOUR APP NAMESPACE  databases Underneath the DDMS icon  there should be a new blue icon of a Database light up when you select your database  Click it and you will see a Questoid Sqlite Manager tab open up to view your data     Note  If the database doesn t light up  it may be because your database doesn t have a   db file extension  Be sure your database is called  DATABASE NAME  db   Note  if you want to use a DB without  db-Extension    Download this Questoid SqLiteBrowser  http   www java2s com Code JarDownload com questoid com questoid sqlitebrowser 1 2 0 jar zip Unzip and put it into eclipse dropins  not Plugins    Check this for more information

[android] How to view data saved in android database(SQLite)?

Examples related to android

Examples related to sqlite