Featured
-
How Regression Testing Detects Integral Errors In Business Processes
Humans are forever changing and evolving and so to
by kristina.rigina -
Get Display Banner Advertising Opportunity on FindNerd Platform
“Do you have a product or service that nee
by manoj.rawat -
Android O Released with Top 7 New Features for App Developers
Android was founded by Andy Rubin, Rich Miner, Nic
by sudhanshu.tripathi -
Top 5 Features That Make Laravel the Best PHP Framework for Development
Laravel is a free open source Web Framework of PHP
by abhishek.tiwari.458 -
Objective C or Swift - Which Technology to Learn for iOS Development?
Swift programming language is completely based on
by siddharth.sindhi
Tags
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;
...
