Category Archives: SQLite

CRUD Operations in SQLite using SQLiteOpenHelper – Android

We do SQLite operations in Android by extending the SQLiteOpenHelper Class. I will create an Employee table with three fields id name company. I have a model class same as the database table Employee. Employee.java Lets see How we can do the CRUD (Create, Read, Update and Delete) Operations. CREATE We create a class that… Read More »

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. First I will just create a Database Helper Class for adding and reading from the Database. Our Database contains only one table “Images” with two columns “id” and “image”. Note : If you want… Read More »

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 »