SQLite Database Tutorial Android Studio | Insert, Delete, Update and View Data in SQLite Database

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ต.ค. 2024

ความคิดเห็น • 261

  • @appci8282
    @appci8282 2 ปีที่แล้ว +1

    Pretty much an excellent tutorial.
    Does what it says in the title.
    Not too short of a video, so nothing skipped.
    Not artificially lengthened by adding extra lists or some other unnecessary output type, to make newbies life harder.
    Perfect.

  • @deniswastaken
    @deniswastaken 6 หลายเดือนก่อน

    can't thank you enough dude, I work on UI section and I have an exam tomorrow, this seems like the only tutorial I needed. you taught the CRUD in very detailed manor, thank you.

  • @sameernilkhan2476
    @sameernilkhan2476 2 ปีที่แล้ว +2

    Hi bro, thanks for such a good lecture, you saved me from getting scolded by my teacher !!!

  • @unicode3402
    @unicode3402 2 ปีที่แล้ว

    You single-handedly saved me today. Thank you!!
    If you follow step by step, it works guys.
    I even edited the code a little bit to use auto-incremented IDs, its working perfectly.
    Thanks again!

  • @kdpathak4788
    @kdpathak4788 3 ปีที่แล้ว +3

    You are a very good teacher
    Thanks for the video

  • @lars802
    @lars802 3 ปีที่แล้ว

    Thank you for a superb tutorial. Very nice! Please correct me if I am wrong, but in the DBHelper class consider to close the database cursor with cursor.close(); after use to release the memory map allocated in the methods where a cursor is being used. Otherwise you're at risk to trigger an allocation exception in a large database with repeated multiple calculations.

  • @k.abo_m
    @k.abo_m ปีที่แล้ว

    This helped me a lot with my project for college. Thank you so so much for such an amazing video. You're a legend!!

  • @tunginh7300
    @tunginh7300 3 ปีที่แล้ว +2

    thank for your good tutorial.
    But I wonder Did you miss close() method ?

  • @rohitbhardwaj8775
    @rohitbhardwaj8775 ปีที่แล้ว +2

    Sir, thank you so much for this SQLite tutorial. It helped me a lot.

  • @skanerkodowkreskowychqr3794
    @skanerkodowkreskowychqr3794 ปีที่แล้ว

    Clear coding. Perfect job. Easy way to understand thanks your video

  • @j2adloe542
    @j2adloe542 3 ปีที่แล้ว +1

    Hi, thank you soo much for this tutorial, it worked really well. May I ask if how do you convert those saved data to an excel file? Thanks!

  • @rajupulidindi8378
    @rajupulidindi8378 ปีที่แล้ว

    Extremely well designed topic, explained through your TH-cam. I am very thankful to you for sharing your knowledge with us. Take care and please share more...

  • @wellmessed
    @wellmessed 3 ปีที่แล้ว

    Thank you very much! very helpful! What would be the correct way to remove the "if" statements so users can enter multiple data entries even if it's the same for name,dob,details etc?

  • @manjuraj3948
    @manjuraj3948 ปีที่แล้ว +1

    Very nice tutorial, explained each and every point , thanking for your video .I made and compiled your program and it worked without any error. Hope to see more

  • @lancetv4826
    @lancetv4826 2 ปีที่แล้ว +1

    thank you, I'm new to android and this helped me.

  • @FantasywithAdi
    @FantasywithAdi 5 หลายเดือนก่อน +1

    I created app like yours SQLite application the code work successfully but Whenever I try to insert data it showing new entry not inserted can you solve this for me

  • @codingtutorials1857
    @codingtutorials1857  2 ปีที่แล้ว +5

    Hi all, I have updated the source code link in the description box.👆👆👆

    • @syedmuhammadsaddam1226
      @syedmuhammadsaddam1226 2 ปีที่แล้ว

      can you tell name of app which you are use for mobile view

    • @codingtutorials1857
      @codingtutorials1857  2 ปีที่แล้ว

      @@syedmuhammadsaddam1226 apower mirror
      You can use smart view in you phone also to connet to PC if they are on the same wifi.

    • @codingtutorials1857
      @codingtutorials1857  2 ปีที่แล้ว

      @@syedmuhammadsaddam1226 Apower Mirror

  • @Tritaa
    @Tritaa 3 ปีที่แล้ว +1

    Hello i have a question
    Can i edit database table of download Android project sorce code??
    Please tell me

  • @emilioocampo9630
    @emilioocampo9630 ปีที่แล้ว +1

    Excellent tutotial, I learned a lot!!! Thank you so much!!!

  • @vishnumuthyalu1346
    @vishnumuthyalu1346 2 หลายเดือนก่อน +2

    Thank you so much for this Sir, it really helped me Sir !

  • @ruellavas5316
    @ruellavas5316 3 ปีที่แล้ว

    so I already have DBHelper.java which I followed from your login-register video So my question is that do i still have to create another db.java class in this insert,delete,update,delete or use it in the same class? as I am connecting the sign in to this update form?

  • @PrayashPanta
    @PrayashPanta 3 ปีที่แล้ว +1

    How to display only the latest data stored in the db when view is pressed ? Thank you.

  • @tilahunm
    @tilahunm 5 หลายเดือนก่อน

    I really appreciate you my dear, You solved all my problems. Thanks again 10000000000000000000 ... Times.

  • @PPCFindingStudio
    @PPCFindingStudio 2 ปีที่แล้ว +1

    Very helpful for beginners. Great work.

  • @prakatneupane2912
    @prakatneupane2912 3 ปีที่แล้ว +1

    how can you validate the data? i mean how can we insert into database only if the input data meets certain criteria?

  • @topdeveloper8955
    @topdeveloper8955 2 ปีที่แล้ว +3

    Done perfectly, thank you

  • @hendywidjaja3697
    @hendywidjaja3697 3 ปีที่แล้ว

    Thank you so much, your tutorial and explanation very detail and helpful. It works perfect !

  • @starletts1alex
    @starletts1alex 3 ปีที่แล้ว

    Great vid, im new to programming and his helped alot with my project. Awesome Vid very easy and simple to follow and understand

  • @sabrinafeliz4822
    @sabrinafeliz4822 3 ปีที่แล้ว

    hello sir please can you tell me the difference between internal and external database and what is the best way to use database in android . thank you

  • @omigoto3377
    @omigoto3377 2 ปีที่แล้ว

    Hello sir i want ask something about sqlite, is it possible if i am using mysql database and make it to be an Api and using sqlite for save the data?

  • @peterkim5853
    @peterkim5853 3 ปีที่แล้ว

    Hi,
    Would you please make a lecture to create sqlitedatabase in google drive and treat it with android app.

  • @D-Coder440
    @D-Coder440 6 หลายเดือนก่อน +1

    Thank you so much, bro. It's fascinating tutorial

  • @29_vinithingmire83
    @29_vinithingmire83 2 ปีที่แล้ว

    Having problem with update data button...after clicking it if same name data is already present in DB then it just returns to the previous page...
    Plz help..

  • @susanoo0217
    @susanoo0217 2 ปีที่แล้ว

    Thanks but I need help, what if I need to insert only one data? how can I stop adding more to it.

  • @nguyenconghoanglong2515
    @nguyenconghoanglong2515 3 ปีที่แล้ว

    why i copy your source ( accept package...) has error: Message: XML document structures must start and end within the same entity.. How can i fix. thank you very much

  • @pintud.581
    @pintud.581 3 ปีที่แล้ว

    Helpful tutorial, can you suggest How to delete multiple table records single query in sqlite database.

  • @ZeeshanAcademy
    @ZeeshanAcademy 3 ปีที่แล้ว +1

    excellent tutorial. thanks it was very helpful

  • @marcjacob11
    @marcjacob11 ปีที่แล้ว

    Hello sir. This video of yours is very helpful! I wonder, is there any possible way that I can create/delete/update a record in a different table? Your help is appreciated. Again, thank you so much for this!

    • @samsons8279
      @samsons8279 6 หลายเดือนก่อน

      The table name must be given in the SQL query while coding itself...
      Without that being done , the program can't locate the table for entering the data...

  • @prasannavenkatesh8674
    @prasannavenkatesh8674 3 ปีที่แล้ว +1

    Thanks a lot man, this content was very useful for my app. I have subscribed and liked the video. Thanks bro.

  • @ManojKumar-tz3sd
    @ManojKumar-tz3sd 3 ปีที่แล้ว

    It can able to save the data when the data is not given manually..what should I need to do to stop saving the empty value

  • @SirDrasticG
    @SirDrasticG 2 ปีที่แล้ว +1

    umm Sir, it seems like i can't insert any data to the database apparently? how do I fix this?

  • @umyhhabiba7199
    @umyhhabiba7199 2 ปีที่แล้ว

    I have used this sourse code for my product details table i am storing products details here
    I was very helpfull
    Can you plz help me ?
    I waNt to search different product by there name in a text view by using button click in other activity
    I want to display records of table if it match in database table
    But my query select query is not working
    I have searched for many times but it was not working for this database plz plz guide me as soon as possible

  • @calvinchow1702
    @calvinchow1702 3 ปีที่แล้ว +2

    Is it possible to do a tutorial on how to view the data in a listView in a new activity?

  • @michelelomonaco5118
    @michelelomonaco5118 2 ปีที่แล้ว

    Hello, congratulations on the great tutorials for beginners. I use my mobile directly via usb and i can't see the database data. I don't see the folder: com.example.sqliteapplication even if I look directly at the mobile, but the application works fine. Where will the data be?
    My mobile is an old Samsung Neon Android 6.0.1
    Thanks for your reply.
    Michele.

    • @codingtutorials1857
      @codingtutorials1857  2 ปีที่แล้ว

      Thanks for liking the video. The database can be seen by installing db viewer in the PC.

    • @michelelomonaco5118
      @michelelomonaco5118 2 ปีที่แล้ว

      @@codingtutorials1857 grazie

  • @manhuc1230
    @manhuc1230 ปีที่แล้ว

    Hi guy, if I have images and audio files, where should I put them in sqlite?

  • @noelkristianberutu3184
    @noelkristianberutu3184 ปีที่แล้ว +1

    thank you so much sir, help me a lot

  • @ivanguzhov6010
    @ivanguzhov6010 2 ปีที่แล้ว

    Thanks a lot! This is very helpful lesson for my project!

  • @elroyrebello3073
    @elroyrebello3073 3 ปีที่แล้ว +1

    Wow lovely toturial all in one

  • @hixen4029
    @hixen4029 2 ปีที่แล้ว

    Very helpful lesson for my project!

  • @berend109
    @berend109 3 ปีที่แล้ว

    Thank you very much, nice and quick video with good explanation.

  • @sameersrivastava3064
    @sameersrivastava3064 หลายเดือนก่อน

    plz explain why you used index number 1,2,3 in string buffer part 22:50

    • @codingtutorials1857
      @codingtutorials1857  หลายเดือนก่อน

      1 2 and 3 are row numbers in which each type of data name etc. are stored.

  • @manibala5799
    @manibala5799 2 ปีที่แล้ว

    Sir can you tell how to view data as list view and control users in list view by clicking button user approved near list view

  • @BinaryVigilante
    @BinaryVigilante ปีที่แล้ว

    Thank you so much for this video, exactly what I have been looking for 👍

  • @sanjaytandukar4325
    @sanjaytandukar4325 3 ปีที่แล้ว +1

    sir how to pre load database that has all data and display data to the users?? So that user do not need to insert data into data base and just view data only.

  • @rishabhsagarmagics
    @rishabhsagarmagics 2 ปีที่แล้ว +1

    How we publish this type of app on google play console, it shows login issue error..

    • @codingtutorials1857
      @codingtutorials1857  2 ปีที่แล้ว

      There is a different procedure for building uploadable apps in playstore . I will make a tutorial in future in this topic

  • @RChintalapudiVaishnavi
    @RChintalapudiVaishnavi 3 ปีที่แล้ว

    Nice Explanation Sir...Thank u so much

  • @RoyAdame
    @RoyAdame ปีที่แล้ว +2

    Thank you so much it works

  • @pidoih23
    @pidoih23 ปีที่แล้ว +1

    thanks a lot bro..appreciated ur tutorial

  • @rafabastos87
    @rafabastos87 ปีที่แล้ว +1

    Thanks for the video! Helped me a lot!

  • @harishreddy8247
    @harishreddy8247 3 ปีที่แล้ว

    Super explaination very nice video sir

  • @funsourcestudio4686
    @funsourcestudio4686 3 ปีที่แล้ว

    Thank you AllCodingTutorials!!

  • @manalmohammed4091
    @manalmohammed4091 3 ปีที่แล้ว

    So Helpful thank you so much👍👍

  • @unloyal6396
    @unloyal6396 2 ปีที่แล้ว

    hello, what if i have more than one activity and i instanciate a new databasehelper each time, does it work on the same database or a different one?
    Thanks in advance!

  • @gigabyte6476
    @gigabyte6476 3 ปีที่แล้ว

    plz tell me if we dont show our data on DB browser then how to do it

  • @poojagirish1101
    @poojagirish1101 ปีที่แล้ว

    If i insert a data and then if i try to insert another one its got coming in sql y?

  • @suatomerbeyoglu3180
    @suatomerbeyoglu3180 ปีที่แล้ว +1

    Thank you so much. It was useful.

  • @Nthng30
    @Nthng30 3 ปีที่แล้ว

    Thank u this is so helpful for me to study

    • @zahidaafzal2732
      @zahidaafzal2732 3 ปีที่แล้ว

      Jeb. Nnjbeabhn es zgah1 be.3ambjeaaàè9qqqqqñasbhhsb
      Dgññeñ p job

    • @zahidaafzal2732
      @zahidaafzal2732 3 ปีที่แล้ว

      Bb h3 e bahnne ed dd

    • @Nthng30
      @Nthng30 3 ปีที่แล้ว

      ?

  • @thabomashaba1583
    @thabomashaba1583 2 ปีที่แล้ว

    Thanks it works, Can i have a tutorial for populating a listview with database Information

    • @codingtutorials1857
      @codingtutorials1857  2 ปีที่แล้ว +2

      Yes I am going to upload recyclerview with Sqlite

    • @thabomashaba1583
      @thabomashaba1583 2 ปีที่แล้ว +1

      @@codingtutorials1857 yes please coz i saw that one for Recycler but it was not exactly what i wanted coz it includes firebase i think

  • @mariofilipovic3484
    @mariofilipovic3484 2 ปีที่แล้ว

    Hello, is this a persistant database? Do the tables stay there after you turn the device off?

    • @codingtutorials1857
      @codingtutorials1857  2 ปีที่แล้ว +1

      Yes it stays in your device even after the device is off. It creates a permanent database file in your app folder.

    • @mariofilipovic3484
      @mariofilipovic3484 2 ปีที่แล้ว

      @@codingtutorials1857 Thank you very much!

  • @sssingh4375
    @sssingh4375 3 ปีที่แล้ว

    TQ so much sir it is very helpful

  • @Kejody53
    @Kejody53 ปีที่แล้ว

    saving my assignment, thanks man

  • @brazo98
    @brazo98 ปีที่แล้ว

    THX a lot for this awesome Tutorial.

  • @rebalpraneeth1666
    @rebalpraneeth1666 10 หลายเดือนก่อน

    Can anyone help me I am stuck at
    Go to cart
    My problem is : data was not add ing to the cart table
    am adding the data into database there no errors and also I have check with log msg but data is not add ing to the cart table

  • @verniadigitalsystem6258
    @verniadigitalsystem6258 3 ปีที่แล้ว

    how to show within the activity page without open in dialog box?

  • @isuruuyanage2
    @isuruuyanage2 4 ปีที่แล้ว

    Thank you so much! Worked like a charm.

  • @amirhoxha6231
    @amirhoxha6231 6 หลายเดือนก่อน

    Very Good Video I love India 🇮🇳 ❤

  • @praffulbisht8520
    @praffulbisht8520 2 ปีที่แล้ว

    Can we access data after closing the app

  • @redzone3171
    @redzone3171 2 ปีที่แล้ว +1

    This is really sick thank you very much for your help really appreciate it

  • @dartdasturchi
    @dartdasturchi 3 ปีที่แล้ว

    Big thanks for you all for

  • @سُمیدڈاغونوّی
    @سُمیدڈاغونوّی 3 ปีที่แล้ว

    admin panel pay ik video banayeang sir using navigation view

  • @MrFearlesskiller
    @MrFearlesskiller 2 ปีที่แล้ว +1

    Im sorry but editing the xml directly like that instead of just dragging a button seems kinda ghetto

  • @vishalaparnathi
    @vishalaparnathi 2 ปีที่แล้ว

    Sir please give me solution for Error:
    Gradle project sync failed. Basic functionality (e.g. editing, debugging) will not work properly
    I tried many ways but didn't work. 😖

    • @candy9193
      @candy9193 2 ปีที่แล้ว +1

      I enabled Visualization in bios , it worked for me

    • @codingtutorials1857
      @codingtutorials1857  2 ปีที่แล้ว

      Hi.
      Please set the build tool version to App level-Gradle by going to FILE---> Project Structure ---> Select "Build Tool Version"... And then sync again.

  • @khaerulfikri
    @khaerulfikri 2 ปีที่แล้ว

    Using Stringbuffer,, nice

  • @EnglishWithSushma
    @EnglishWithSushma 2 ปีที่แล้ว +1

    Please add more videos of Android tutorials

    • @codingtutorials1857
      @codingtutorials1857  2 ปีที่แล้ว

      Uploaded video on firebase login. Also uploading today phone authentication firebase app. Stay tuned...

    • @EnglishWithSushma
      @EnglishWithSushma 2 ปีที่แล้ว

      @@codingtutorials1857 yeah sure.. let me press the bell icon.

  • @donroger9164
    @donroger9164 3 ปีที่แล้ว

    Hey how do i connect the database to other apps?

  • @gururajkl6755
    @gururajkl6755 3 ปีที่แล้ว +1

    can u say which s/w need to download for that database

    • @mathsaddiction3
      @mathsaddiction3 3 ปีที่แล้ว +1

      Just Install Android Studio..SQLite is inbuilt in it...

    • @gururajkl6755
      @gururajkl6755 3 ปีที่แล้ว +1

      @@mathsaddiction3 ty

    • @vaishnavichimote8415
      @vaishnavichimote8415 3 ปีที่แล้ว

      If we have to see this dB then how to view these table

  • @usha143
    @usha143 4 ปีที่แล้ว +1

    Can you provide the src?

  • @alpha__321
    @alpha__321 2 ปีที่แล้ว +1

    manh thanks dude for this wonderfull vedio

  • @yuvaasrikesavan9509
    @yuvaasrikesavan9509 2 ปีที่แล้ว +1

    Where does the inserted data store in mobile after import the app to mobile

    • @codingtutorials1857
      @codingtutorials1857  2 ปีที่แล้ว +2

      Inserted data is stored in the app database file in the phone memory. Thanks for asking.

  • @bambakane188
    @bambakane188 4 ปีที่แล้ว

    Do you speack french i have some problem whith a quizz application

  • @janreimarbague3571
    @janreimarbague3571 ปีที่แล้ว +1

    Thanks Man great tutorial

  • @MayaMaya-dm3pb
    @MayaMaya-dm3pb 3 ปีที่แล้ว

    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

  • @theblackmagition2654
    @theblackmagition2654 2 ปีที่แล้ว +1

    how i add picture in addition?

  • @ganeshrathod8867
    @ganeshrathod8867 4 ปีที่แล้ว

    sir data not inserted in above video method

  • @muhammadzahoor1677
    @muhammadzahoor1677 ปีที่แล้ว

    How we can show specific data by number?

  • @mbaqirismail8780
    @mbaqirismail8780 8 หลายเดือนก่อน +3

    Nice

  • @NVMegaboyyy6
    @NVMegaboyyy6 3 ปีที่แล้ว

    When I fill in data, then press the add button but "Data not inserted" and if I press another button (view / update / delete) it will close the application / application stops.
    where did it go wrong? Anyone knows? please help me

    • @vudo488
      @vudo488 3 ปีที่แล้ว

      I'm having the same issue. The "Insert new data" button return the toast message successfully but not the other buttons. Have you figure it out?

  • @MrFearlesskiller
    @MrFearlesskiller 2 ปีที่แล้ว

    Also, isnt it better to do an onClick event through the attributes then define it instead of doing all of that in the main activity method

    • @williamselinder9138
      @williamselinder9138 2 ปีที่แล้ว

      Well, then it will be harder for you to locate what the function is attributed to, if you write big long code with alot of activities you might end up forgetting it.

  • @guardianschool8075
    @guardianschool8075 3 ปีที่แล้ว

    Android resource linking failed how to resolve this error

  • @zonekenne5329
    @zonekenne5329 2 ปีที่แล้ว

    I've issues with the View Button. when i click on it, the programm stops running.