In this tutorial we will see how to save an image as a string in preferences. Watch more flutter videos on my youtube channel here. Watch Video Tutorial Add Dependencies First thing we have to do is to add the plugins. Open pubspec.yaml file and add the below Dependencies. So Let’s start… First we will… Read More »
Watch Video Tutorial Add Dependency SQFlite is a Flutter library for doing local Database Operations. You can download it from here. To Integrate SQFlite library in your project In your flutter project add the dependency: You can download the sample project from here. employee.dart Database Utils Here is a sample DB Utility file. DBHelper.dart… Read More »
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 »
Introduced in Android 3.0, loaders make it easy to asynchronously load data in an activity or fragment. Loaders have these characteristics: They are available to every Activity and Fragment. They provide asynchronous loading of data. They monitor the source of their data and deliver new results when the content changes. They automatically reconnect to the… Read More »
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 »
Here is a simple example showing how to load a database values in a spinner in android. OK we will start. This is the layout for the spinner row. spinner_row.xml This is the layout for the interface. activity_main.xml Now this is the MainActivity.java file that uses the spinner and the database. Join the Forum discussion… Read More »
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 »
Hello all, In todays tutorial I will show you how to work with sqlite databases in android through command line. Advantages 1. You can browse any number of databases. 2. You can write any queries and execute. First go through these tutorials to get a glance of how to work with sqlite databases in android.… Read More »
When you are working on an Android application that stores data in a SQLite database.There arise many questions like where does this database file get stored on the filesystem ? How can we access the database? I will give solution to all these problems. I created the SQLite database from my previous post about Using… Read More »
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 »
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 »
Certainly! SQL (Structured Query Language) is used to interact with relational databases. Here are some common SQL commands with examples: Example: Example: Example: Example: Example: Example: Example: Example: These are just a few examples of common SQL commands. SQL is a powerful language with many features, and its usage can vary depending on the specific… Read More »
In this demo we will create a flutter app that communicates with the Server and create a table, insert records, update records, fetch all records and delete records. The Data from the Server will be displayed in a DataTable. Watch Video Tutorial Here I am using XAMPP to create a local Server. You can download… Read More »
We are going to create an Offline Database using data from a Webservice. Watch Video Tutorial We are going to use the below service for that. https://jsonplaceholder.typicode.com/photos This service has about 5000 records, we are going to parse these records and insert all the records into the Offline SQLite database. Generate JSON Models To create… Read More »
Visit my youtube channel here. Google’s Flutter Tutorial – Share Data to other applications. Google’s Flutter Tutorial – Upload Image to Server Google Flutter Tutorial – Tabbed AppBar Google Flutter Tutorial – Carousel Google Flutter Tutorial – Gradients Google Flutter Tutorial – Bottom… Read More »
Hi Friends, Today we will see how to implement GridView in Flutter. We are going to use this service for the data First we will create a Model for the Grid Cell No we will create view for Grid Cell Create a file named “cell.dart” and copy this into it. Service Class We… Read More »
Lets talk about the Room Persistent Library from Google. The Room persistence library provides an abstraction layer over SQLite to allow fluent database access while harnessing the full power of SQLite. The library helps you create a cache of your app’s data on a device that’s running your app. This cache, which serves as your… Read More »
Introduced in Android 3.0, loaders make it easy to asynchronously load data in an activity or fragment. Loaders have these characteristics: They are available to every Activity and Fragment. They provide asynchronous loading of data. They monitor the source of their data and deliver new results when the content changes. They automatically reconnect to the… Read More »
In this tutorial we will be making a simple application to save a person details using Core Data. Here we will have two models or it can be said as Database tables – Model1 and Model2. Below are the basic things about Core Data… Core Data Stack The key objects of the stack are the… Read More »
Hello all we all know what are content providers right? Those who are unaware of content providers please visit this link http://developer.android.com/guide/topics/providers/content-providers.html In a breif content Providers are Content providers manage access to a structured set of data. They encapsulate the data, and provide mechanisms for defining data security. Content providers are the standard interface… Read More »
Here we are accessing a mysql database and get the table values and show it in the Android side as tables. These are some tutorials that I have posted on connection with php and getting tablevalues. 1. Android phpmySQL connection redone. 2. Simplest Lazy Loading ListView Example in Android with data populated from a MySQL… Read More »
If you have installed Avast and the Avast anti theft application on your Android and decide you no longer need it, you may find it difficult to remove. It is protected so you first need to remove it’s protection. Here’s how to do it. Go to Device Settings Security Select Device Administrators – you can… Read More »
Hello all………. We have seen many posts about ListViews like creating a listview, adding data to it, customizing a listview etc. Take a look at some of these examples 1. Single Selection ListView in android 2. Flitering a ListView using an input from an EditText in Android. 3. How to create a custom ListView in… Read More »
Hello Friends Today I will show you how to save data in cocos2D android in a database and reload it when the game starts. This has been always a problem withe game developers for cocos2D android. I will show you a way to save almost any number of data in a database using SQlite in… Read More »