Android SQLite Tutorial | Android CRUD Tutorial with SQLite (Create, Read, Update, Delete) | #Part 1

preview_player
ะŸะพะบะฐะทะฐั‚ัŒ ะพะฟะธัะฐะฝะธะต
#๐๐š๐ซ๐ญ ๐Ÿ (๐ˆ๐ง๐ฌ๐ž๐ซ๐ญ ๐€๐ง๐ ๐‘๐ž๐š๐ ๐ƒ๐š๐ญ๐š)
Hello Guys,In this ๐š๐ง๐๐ซ๐จ๐ข๐ ๐ฌ๐ญ๐ฎ๐๐ข๐จ tutorial we will learn to ๐ข๐ง๐ฌ๐ž๐ซ๐ญ,๐ฎ๐ฉ๐๐š๐ญ๐ž,๐๐ž๐ฅ๐ž๐ญ๐ž,๐ฌ๐ž๐ฅ๐ž๐œ๐ญ data in ๐’๐๐‹๐ข๐ญ๐ž D๐š๐ญ๐š๐›๐š๐ฌ๐ž.in this example we will store ๐ž๐ฆ๐ฉ๐ฅ๐จ๐ฒ๐ž๐ž name,email in to ๐’๐๐‹๐ข๐ญ๐ž D๐š๐ญ๐š๐›๐š๐ฌ๐ž and then select and modify data in ๐’๐๐‹๐ข๐ญ๐ž D๐š๐ญ๐š๐›๐š๐ฌ๐ž in very simple way.

๐–๐ก๐š๐ญ ๐ข๐ฌ ๐’๐๐‹๐ข๐ญ๐ž ?
-SQLite is a opensource SQL database that stores data to a text file on a device. Android comes in with built in SQLite database implementation.

-To use SQLiteOpenHelper, create a subclass that overrides the onCreate() and onUpgrade() callback methods.

-SQLite supports all the relational database features. In order to access this database, you don't need to establish any kind of connections for it like JDBC,ODBC ,MySql e.t.c

๐ƒ๐š๐ญ๐š๐›๐š๐ฌ๐ž - ๐‡๐ž๐ฅ๐ฉ๐ž๐ซ ๐œ๐ฅ๐š๐ฌ๐ฌ
For managing all the operations related to the database , an helper class has been given and is called SQLiteOpenHelper. It automatically manages the creation and update of the database. Its syntax is given below

๐ƒ๐š๐ญ๐š๐›๐š๐ฌ๐ž - ๐‚๐ซ๐ž๐š๐ญ๐ข๐จ๐ง
In order to create a database you just need to call this method openOrCreateDatabase with your database name and mode as a parameter. It returns an instance of SQLite database which you have to receive in your own object.

๐ƒ๐š๐ญ๐š๐›๐š๐ฌ๐ž - ๐ˆ๐ง๐ฌ๐ž๐ซ๐ญ๐ข๐จ๐ง
we can create table or insert data into table using execSQL method defined in SQLiteDatabase class.

๐ƒ๐š๐ญ๐š๐›๐š๐ฌ๐ž - ๐…๐ž๐ญ๐œ๐ก๐ข๐ง๐ 
We can retrieve anything from database using an object of the Cursor class. We will call a method of this class called rawQuery and it will return a resultset with the cursor pointing to the table. We can move the cursor forward and retrieve the data.

Please ๐Ÿ‘๐‹๐ข๐ค๐ž ,๐Ÿ‘ค๐—ฆ๐—ต๐—ฒ๐—ฎ๐—ฟ,โœŽ๐‚๐จ๐ฆ๐ฆ๐ž๐ง๐ญ And โ˜๐’แดœส™๐’ส€ษชส™แด‡ My ๐—ฌ๐—ข๐—จ๐—ง๐—จ๐—•๐—˜ Channel

๐…๐จ๐ซ ๐๐ฎ๐ฌ๐ฌ๐ข๐ง๐ž๐ฌ๐ฌ ๐ˆ๐ง๐ช๐ฎ๐ข๐ซ๐ข๐ž๐ฌ

๐’แดœส™๐’ส€ษชส™แด‡ My ๐—ฌ๐—ข๐—จ๐—ง๐—จ๐—•๐—˜ Channel #๐—ฐ๐—ผ๐—ฑ๐—ถ๐—ป๐—ด๐˜„๐—ถ๐˜๐—ฑ๐—ฒ๐˜ƒ for more latest videos..
Thank You :-)

#SQLite #AndroidStudioTutorial #CRUD #sqlitedatabase #create #update #read #delete #Android #EmployeeDirectoryApp #recyclerview #listview

#sqlite database in android example step by step
#how to connect sqlite database in android studio
#how to insert data in sqlite database in android studio
#how to store data in sqlite database in android example
#how to insert and retrieve data from sqlite database in android
#simple sqlite database example in android
#android sqlite tutorial for beginners
#Setting up an Android SQlite Database - Employee Directory App #1
ะ ะตะบะพะผะตะฝะดะฐั†ะธะธ ะฟะพ ั‚ะตะผะต
ะšะพะผะผะตะฝั‚ะฐั€ะธะธ
ะะฒั‚ะพั€

thank you so much sir I was depressed from 3 days and I thought android development is not made for me so I found your video and this helped me so much thanks !

NIKHILKUMAR-cpdl
ะะฒั‚ะพั€

Finally a video that has taken me step by step to finish-line successfully.
Though my device did not display the "View Employee" data...
I guess it's because I'm using the Android Device, and this needs external device.
Thank you so much.

jothamithagu
ะะฒั‚ะพั€

Thanks so much for your video, it's easy to understand.

luannguyenthanh
ะะฒั‚ะพั€

Thank you, your video helped me a lot!

Tridez
ะะฒั‚ะพั€

I JUST SUBSCRIBED TO YOUR CHANNEL!! YOU BRILIANT THANK YOU!!!

sibusisom
ะะฒั‚ะพั€

Sqlite is local DB. How can we use android with a remote database like Sql server

ibrahimalmesbahi
ะะฒั‚ะพั€

Hello sir, when i try to enter the view employee, the app keeps crashing can you help me pls

bouchentoufothman
ะะฒั‚ะพั€

Sir i have an error:-
Recyclerview: No adapter attached; skipping layout
And i have add :- item. Size () then alsowi got same error
Sir please can u solve my error

radhikapatel
ะะฒั‚ะพั€

whats the use of implementation in gradle? i dont get it.

GeorgeR-dtyu
ะะฒั‚ะพั€

Hello sir, this was really helpful. Can please say how to do switch button coding and connect to database?

priyankashivappa
ะะฒั‚ะพั€

Please sir i have a problem, โ€œno adapter attached;skipping layout โ€œ
You can please resolve it?

hasankanaan
ะะฒั‚ะพั€

Could anybody help out how can I connect this entered data with DB browser app so that I can connect this datas to other applications I devolepe

MayaMaya-dmpb
ะะฒั‚ะพั€

Sir how can we get numbers from sqlite and store them in string variables

education_beauty
ะะฒั‚ะพั€

Iam just followed your instructions, but when i run the project and add email there is show "there is no empoloyee in the database"

aulairvanzidnivavan
ะะฒั‚ะพั€

Sir i have error :no adapter attached skipping layou pls give me solution for that

vishalrathod-fqsb
ะะฒั‚ะพั€

Hello, could you help me please. I can't see the content

vermlon
ะะฒั‚ะพั€

I followed the sample code. All the data add to the database in insert part. but when I click on view button the app doesn't response. could you please help me?

shashikrishan
ะะฒั‚ะพั€

is there a kotlin version of this tutorial bro?

jhoncarlosdrilon
ะะฒั‚ะพั€

I need source code plz. Where is source code. There is nothing in github

zkk
ะะฒั‚ะพั€

i have an error in select * from what should i do

lucyakimoto