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

Featured

How to save and fetch data from Sqlite database

First include the sqlite file in your project. Then copy that file from bundle to documents directory as below and create Database method. -(void)createDatabase{ NSString *pathForDocumentDirectory =[self databasePath]; //define new path...

How to fetch data from SQLite in iOS?

Hi Readers, This blog includes the concept of how to fetch data from database after saving the data. You can go through with previous blog if you are not aware about  how to save data How to save data in SQLite. Now we will discuss the ...

How to save data in SQLite database in iOS?

Hi Readers, In this blog, we will discuss how to save data entered by a user in SQLite database. Before proceeding towards the saving of data into the database you should know how to create a database and tables inside SQLite database. ...

Insert data into database from form in PHP

Below is a form which contain id field, name field, phone number filed, gender radio button and we are sending these data  by using post method. <form name="user_registration" method="post" > Name: <input type="text" name...

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: