Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

How to remove item from RecyclerView DataBase Sqlite helper class(RecyclerView)

Here I have created a method in DataBase helper(sqlite) to remove Items from RecyclerView. In the example code first i have created deleteCallDetail method and after then In Adpter class I have used ClickListener, so that when we click on cross(I...

Login Authentication

Below i have written the code for Login Authentication, this code will check that weather the entered name and password are there in database or not. The following code will return true boolean value if the entered name and password exist in dat...

To create database and insert data in SQLite, in android

If you are looking for the code in android to create database and insert data in SQLite then follow the steps mentioned below:- 1) Create a layout in which the data will be filled that will be inserted into database. activity_signup_form....

ATTACH SQLite Database

Hi, Sometimes, we have many database and we need to use any one of them. In this situation we use SQLite ATTACH DATASE statement to choose a specific database. Syntax of the command: ATTACH Database ‘YOUR_DATASE_NAME’ As ‘Alias-Name’; ...

How to add new Columns to table without loosing data of the older version

I am writing this blog to add columns in our database table which would compatible with old version of database. Here I use Alter Table command on my onUpgrade() method where I make condition for the database version. We can add only one column...

Inserting data in android SQLITE table

Hi again, Here we are going to learn how to insert data in the already created table in android SQLITE. You will find it useful if you are aware of the basic terminology of the android SQLITE, if not and you want to create a table so it will be...

Creating a table in android SQLITE

There are situation when we need to maintain(store) data at our application level, this is mainly done when we try to execute functionalists at offline mode. So for these kind scenarios android sdk has provide us class known as SQLiteOpenHelper w...

Use ORMLite to Optimize your sqlite database

Hey, are you working with large database having many columns and many queries . Is this working slow with sqlite? Thanks to ORMLite that manages your database very efficiently as well as no need to manage lots of queries.... ORMLite supports ...

Use existing sqlite database in android

I will show you the easiest solution, by far, is to use SQLiteAssetHelper. You add your existing sqlite database in a specified location in your project's assets/ directory, then use SQLiteAssetHelper to access your database (much same as you wo...

How To use dataBase in Your android App

Use DataBase Helper Class in your code, Which extends the base class SQLiteOpenHelper Class Sample code package com.searchoffers.android; import java.util.ArrayList; import java.util.List; import android.content.ContentValues; ...
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: