Category Archives: SQLite

How to store an Image from Android to a SQlite and retrieve it?

Hello all… In today’s post I will show you how to store an image in an SQLite database and retrieve it. Check out the output after running the program. This is the layout for the MainActivity. Now the code for the Activity. MainActivity.java Please leave your valuable comments.

How to find your Google Plus ID

This is so simple 1. Go to your Google + account (https://plus.google.com/). 2. Click on the Profile icon on the Left. 3. If you look at the URL in the address bar, it should look something like this: https://plus.google.com/104653270154306099169/posts 4. The long numerical string in the URL is your Google+ ID. Here is CoderzHeaven’s from… Read More »

How to save CheckBox values in SQlite Database and Load it later?

Hello…….. This post is just a simple demonstration to show a way to store a checkbox value in a database and reload it. Here I am storing only a value of a single checkbox and reloading it. But you can make changes in the code to save the id and value of the checkbox in… Read More »

How to use SQLite in ANDROID, A really simple example.

Hello ANDROID Lovers…….. In today’s tutorial I will show you how to deal with SQLite Databases in ANDROID. You know that SQLite are Lightweight databases which is maintained only on the client side. They don’t need a server. The SQLite databases are simply a file wrapped around with some stuff which helps us deal with… Read More »

Working with SQLite Database in ANDROID.

Below is a straight forward example of how to deal with SQLite database in ANDROID. Go ahead and copy and paste the following code to your java file. The example has one database and performs functions like insert delete and listing of values in a textView. In the XML file set up a TableLayout with… Read More »