Step 5) Now what we’re going to do is, while creating the database in the previous tutorial we created a class named database helper class for handling our database. Step 4) Now what we’re going to do is, we’re going to take a button and we’re going to change the text to 'Add Data' and also change the ID to button ad.

So it’ll increment automatically when you insert some data inside your table, so we don’t need to add this ID specifically.

Step 3) Now you maybe thinking that we have four columns in our table, first is ID, second is the name, third is surname an fourth is marks, but we have taken only three, you know three variables here. If you want you can change the ID names of these text views and added texts also. So first is the name, the second is surname and third is marks. Step 2) Now we are going to change the last text labels as the column names of our table. Read About How to Create Database and Tables in Android SQLite What I’m going to do is, I’m going to drag three large texts here and three plain texts. So that we can use them to insert some data. In a blank activity we are going to drag and drop some text views here and some added texts here. Step 1) First of all go to your activity.xml file and go to the design tab there. Please follow the below steps in order insert some data in the table inside that SQlite Databse: In this tutorial, we will learn how to insert data into SQLite database in Android with example: How to Insert data into SQLite database in Android? Any data stored in SQLite database can easily accessible from Android Device Monitor without establishing any kind of connections for it such as JDBC. Android SQLite is the most preferred method of storing data in any android applications.Īndroid SQLite is a relational database, therefore, It supports all types of relational database features. Android SQLite is a lightweight and opensouce SQL database that stores data to a text file on a device.

Sqlite database in android