Notes App - CRUD SQLite Database in Android Studio using Kotlin | Create Read Update Delete Data

Подписаться 20 тыс.

Просмотров 38 тыс.

50% 1

Welcome to Android Knowledge!
In this video, we will learn how to create, read, update and delete data or note in sqlite database in android studio using kotlin - Notes App Part 1, 2, 3, 4.
Individual Videos:
1. Create Data in SQLite Database - Notes App Part 1
• Notes App - Store Data...
2. Read Data from SQLite Database - Notes App Part 2
• Notes App - Retrieve D...
3. Update Data in SQLite Database - Notes App Part 3
• Notes App - Update Dat...
4. Delete Data in SQLite Database - Notes App Part 4
• Notes App - Delete Dat...
CRUD SQLite Database in Android Studio using Kotlin:
• Notes App - CRUD SQLit...
Android - Kotlin (Beginners to Advanced) Playlist:
• Android - Kotlin (Begi...
SQLite DB Browser Software Link:
sqlitebrowser.org/dl/
Join our Telegram Group:
t.me/androidknowledge
Instagram:
/ android_knowledge
My Best Laptop for Android Development:
amzn.to/3wVfgnE
Website:
androidknowledge.com
My Laptop SSD for Fast Android Studio Experience:
amzn.to/40qvoLo
My Laptop Stand with Cooling Fans - Avoid Heating Due to Android Studio:
amzn.to/3RxeGpV
If you have any queries or errors, please feel free to comment below :-)
Please subscribe to my channel 😊👍
Chapters:
00:00:00 - Intro
00:00:08 - Create SQL
00:26:26 - Read SQL
00:44:56 - Update SQL
01:07:08 - Delete SQL
1:15:50 - Outro
Hashtags:
#android #androidstudio #kotlin #androiddevelopment #mobileappdevelopment
Keywords:
Notes App - CRUD SQLite Database in Android Studio using Kotlin | Create Read Update Delete Data
crud operations in android studio,crud operation in sqlite android,notes app android studio source code,sqlite notes app android,learn to build android apps for free,android sqlite notes database example,sqlite notes with crud android,android projects,android app user,notes database project,android projects for beginners, todo list database example,project ideas,kotlin, cread, read, update, delete, store, retrieve, display data, retrieve data from database, delete the data, crud data in sqlite, crud data in the database, notes todo list crud project for beginners, create notes app in android studio, create a todolist in android studio using kotlin, edit note, delete note, create note, store note, display note, read note.
Disclaimer:
We are a participant in the Amazon Associates Program, an affiliate marketing program designed to provide a means for us to earn fees when you click on a product link and make a purchase at no extra cost to you.
All rights reserved by Android Knowledge ©

Наука

Опубликовано:

2 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 69

@samanthaeftink5327 8 месяцев назад

You do an amazing job of pronouncing things clearly and explaining the info so that it is easy to understand. Thank You!

@MusashidenTutoriais2 2 месяца назад

Very nice tutorial. But since the tutorial was recorded using 28 API level, I had to make some minor changes to my code. Plus, I added a search function and a confirm dialog to delete and it's working flawlessly. Thank you very much.

@isharasandaruwan5694 25 дней назад

this video was exactly what I needed! Straight to the point and incredibly useful. Thanks for sharing your expertise!

@Al-Balag3294 9 месяцев назад

A very important video series on Kotlin, it would have been better if there was a search bar to search the notes, Please upload a video for the search bar

@JoaoPaulo-rr8re 6 месяцев назад

A big hug from UFC - Gardens of Anita , Thank you!!

@rupertgennard8955 6 месяцев назад

i like this series. I would love to see you add a search bar and a copy note to the app

@AddyBhardwaj-og9dx 9 месяцев назад

You are doing great, Keep it up. But i have a suggestion, Previously you made video of Firebase reltime database CRUD operation on different modules. Now make an app in which single module and User perform CRUD operations in their Profile section. And all user data can view in Single list. only own details can be modify others User details in list can be read only. Also add search & filter option in list.

@ChrisNemes 4 месяца назад

Thank You for this video! It was very helpful for me, as I wanted to make my first android app! Simple, clear, easy to follow! ;-)

@novayoutube2937 9 месяцев назад

Thanks ma'am, it very helpful 😍

@maresolaris Месяц назад

Thank you very much for this very great tutorial on the issue(s) of creating a very useful Note-taking app with Kotlin. Delightful pace and encouraging motivation. You are an excellent teacher, leaving nothing unmentioned and pointing out where possible errors might occur. You gained a fan!

@android_knowledge Месяц назад

This means alot :-)

@sidahmedsarah4826 8 месяцев назад

I was so excited for this project and I loved it so much that I created it in one day 😂 thank you, awesome as always🎉

@android_knowledge 8 месяцев назад

Great, keep learning :-)

@ShortBits786 3 месяца назад

Thanks Mam Tutorial is Wonderfull

@j7coder 8 месяцев назад

Good Works! Keep making project in android with kotlin. You are amazing!

@android_knowledge 8 месяцев назад

Thank you :-)

@vikashtiwari8360 9 месяцев назад

Mam please bring videos on mvvm and room database

@thavaratnamashendra5879 23 дня назад

Thank you so much for this valuable video. You made this video with detailed information. Really helpful ❤

@ravindu.Perera 19 дней назад

thank you so much for your guidences :)

@xFuuuuuuryX 6 месяцев назад

I LOVE YOu, you saved my day godess!!!!!!!!!

@user-iv3jg1jn9z 5 месяцев назад

Thankyou Ma'am thanks 😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍Loved it

@kithminiranasinghe2603 21 день назад

Thank you so much for your video😍😍

@Bli8tz 5 месяцев назад

why am I getting a java null pointer exception when I try to open the page notes layout? caused by getAllNotes

@jamaal1282 8 месяцев назад

Do you have Github repositary?

@tutrieu3250 8 месяцев назад

sir . I need you choose topic Content provider is next video . Because content provider very hard with me and content provider kotlin very little

@wog4299 6 месяцев назад

Nice explanation...

@KhanhVotrung 14 часов назад

Hello, I am having problems with the database error: android.database.CursorIndexOutOfBoundsException: Index 0 requested, with a size of 0 when I try to run the fragment val db = readableDatabase val query = "SELECT * FROM $TABLENAME WHERE $COLUMN_ID = $note_Id" val cursor = db.rawQuery(query, null) cursor.moveToFirst() can you help me

@ExSkope 5 месяцев назад

how did you write the code in floating the add button?

@alsi9217 7 месяцев назад

Good job👍

@SupunMadushanka-np6gs 22 дня назад

Thank you so much madam

@ashenthiwanka6009 22 дня назад

Good job madam

@octta723 2 месяца назад

best video ever

@memeshorts0113 9 месяцев назад

Oooh thank you mam for this projects video😍... Mam advance series kab aayege?

@android_knowledge 9 месяцев назад

From sept :-)

@arcreations7680 8 месяцев назад

Your videos are great. Also make the video on room database.

@android_knowledge 8 месяцев назад

Soon :-)

@21flame72 Месяц назад

can make a video for this in java and firebase

@NGUYENNGOTRAMY Месяц назад

thank u very much

@danakatzman4500 4 месяца назад

Theres no code for this project on your website, only for the room version

@alonsomercado1457 6 месяцев назад

at the moment that I try to run, this wild error merge: Error running 'AddNoteActivity' The activity must be exported or contain an intent-filter Ideas?

@android_knowledge 6 месяцев назад

Check the below link and also make sure that AddNoteActivity is present in AndroidManifest: stackoverflow.com/questions/40508303/the-activity-must-be-exported-or-contain-an-intent-filter

@officialzaid9158 9 месяцев назад

Pls quotes app how to make?

@mohammed-akk 9 месяцев назад

bro, we need like this video but with using java

@fredjakaa246 9 месяцев назад

🎉🎉🎉

@sorruss6367 28 дней назад

Your voice is cute.

@gufraanshaikh3798 9 месяцев назад

🤩

@sameershah1492 3 месяца назад

❤❤❤❤

@tutrieu3250 8 месяцев назад

Sir update crashes app:Caused by: android.database.CursorIndexOutOfBoundsException: Index -1 requested, with a size of 1

@android_knowledge 8 месяцев назад

Check the below link: stackoverflow.com/questions/19974442/android-database-cursorindexoutofboundsexception

@roteks1910 6 месяцев назад

possible solution: in my case I misspelled "INTEGER" as "INTIGER" in NotesDatabaseHelper in function onCreate override fun onCreate(db: SQLiteDatabase?) { val createTableQuery = "CREATE TABLE $TABLE_NAME ($COLUMN_ID INTEGER PRIMARY KEY, $COLUMN_TITLE TEXT, $COLUMN_CONTENT TEXT)" db?.execSQL(createTableQuery) }

@MyCarlosMelo 7 месяцев назад

Hello Thanks, the app is amazing. Tell me, How can I connect to Firebase in real time? Thanks.

@android_knowledge 7 месяцев назад

You can refer the below video to get an idea on how to connect to firebase realtime: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WH8XOoZLmTA.html

@MyCarlosMelo 7 месяцев назад

@@android_knowledge Good afternoon I'm sorry, but I can't do it, I don't know if I'm doing something wrong. Can you help me? Can I send you my email? Thank you very much.

@MyCarlosMelo 7 месяцев назад

@@android_knowledge I've already managed to record on Firebase. But now I can't see it on "notesRecyclerView". Can you help me? Thanks

@adibrahmadi7663 6 месяцев назад

50:30

@jamesclaveria2906 7 месяцев назад

how to downlaod db browser maam? I cant find tutorial

@android_knowledge 7 месяцев назад

Download from the below link: Link: sqlitebrowser.org/dl/ For windows - download standard installer either for 32bit or 64 bit as per your laptop requirement.

@jamesclaveria2906 7 месяцев назад

@@android_knowledge hi I have requeste can you make video about adding a date, change color of notes , search and adding Image please 🙏🙏🙏

@medbensalem8710 5 месяцев назад

code source please

@cricketworldhighlight 2 месяца назад

Please share the link to the source code.

@kcrules886 23 дня назад

Plese give me the source code

@shivamtiwari8106 3 месяца назад

code likha kar na ki paste kiya karo ..people are here to learn not copy code

@android_knowledge 3 месяца назад

If the code is same then only I copy paste it otherwise the video will become very lengthy :-)

@syedqutub9027 5 месяцев назад

In onBindViewHolder i can't call title and content. How can I solve it? override fun onBindViewHolder(holder: NoteViewHolder, position: Int) { val note = notes[position] holder.titleTextView.text = note.title holder.contentTextView.text = note.content }

@android_knowledge 5 месяцев назад

Make sure you have initialised title and content in NotesViewHolder class and also make sure onCreateViewHolder code is correct.