Well you have done all procedure for creating database and
add entry but when you fetch records there is no record found so how you
overcome this problem ? or How to get Database file from my project in eclipse ? there are many question around it(Same questions) and today in this
tutorial(For android) I am going to show you how and which tool you can use. Sql lite browser is best and
open source tool which you can use to open your database file. But how you find
your database file.
OK I am gone show you step by step procedure which you can
follow to find your data base file and open it in this tool so you can find
your problem solution. Lets say you have problem or error say no table or view
find so you can open database file and can see which table or view exist. Sqllite browser tool allow you to perform all operation over database like insert, update , delete and fire trigger or procedure over database.
- Start your emulator (it is must).
- Now to get your database file open DDMS view in eclipse and go to file explorer Tab .
- In data/data find your application folder (name is same as your package name).
- In your package folder go to database folder where you find your database file just like this image (1 in image).
- To export it click on first option of the menu (2) and export it to the desktop or any where you want.
- Now download sqlite browser from here.
- Now extract it from zip file using and extractor (7zip,winrar).
- Run sqlite.exe given in folder now drag your data base file in it.
- It will look like below image.
As you can see it display all tables and View available in
my db file. So now you can find out what mistake you have done in database
coding and can solve your error. You can also find Tutorial on database which
cover all operations.
If you have any
query post it into the below comment section.
Keep coding and cheers …
0 comments :
Post a Comment