Implementation of SQLite Database in Android using Kotlin

Поділитися
Вставка
  • Опубліковано 7 жов 2020
  • This video explains step by step implementation of SQLite Database in Android using Kotlin.
    Video demonstrates following concepts of SQLiteDatabase
    First, Next, Previous, Last, Insert, Update, Delete & View All Operations.
    Video covers following topics of Android
    ContextMenu, ListView, SearchView, SimpleCursorAdapter, AlertDialog, SQLiteDatabase, Cursor, SQLiteOpenHelper
    Keep Learning
    Thank You

КОМЕНТАРІ • 73

  • @Pro_coder.007
    @Pro_coder.007 4 місяці тому +2

    Great explanation sir love it ❤

  • @rajrajesh1669
    @rajrajesh1669 Рік тому +2

    Hi Sir,
    I'm from chennai,tamilnadu,india.
    After completing my degree,I had no clue what i have to do to get a job.then I started working on improving my skills on programming and I learnt my programming knowledge only through free online sources like youtube ,udemy ,geeksforgeeks ,etc.
    Now,I got myself placed as a soft engineer in a decent company.
    So far I've came across many tutorial videos from many different people in my journey of learning.In my opinion, Usually, it's the americans or generally foreigners who teach well on this programming topic but I've never seen someone explaining the way you do and I'm so proud that you're an Indian more than you would,Sir.
    I'm so impressed by your work and you're posting these for free.
    Purely, these tutorials of yours are gems but sadly you're not getting the recognition that you deserve.

    • @DrParagShukla
      @DrParagShukla  Рік тому +1

      Congratulations for your placement.
      Glad to hear that and really thankful to you for your inspirational words.
      Please share to needy people and learners.

  • @sanjaikumar7706
    @sanjaikumar7706 3 роки тому +3

    One of the best android tutorials !!! Most underrated video in android dev !!

  • @libinscuk
    @libinscuk 2 роки тому +3

    Thank you so so much for this simple and elegant video. Love from Ireland. Keeping adding more. Cheers to you Sir!

    • @DrParagShukla
      @DrParagShukla  2 роки тому +1

      My Pleasure
      Thank you for your kind words

  • @kskksk830
    @kskksk830 2 роки тому +3

    I'm not wrong. you are eccelent. because we can know things but we don't know how to teach them. but you, you are a great teacher. thank you so much Dr. Parag Shukla

    • @DrParagShukla
      @DrParagShukla  2 роки тому +1

      Thank you so much for your kind words.

  • @marcianojaniola2130
    @marcianojaniola2130 Рік тому +2

    Good day Sir Dr. Parag Shukla, if you read this comment... I WAnna say Thank you.. u are a great Teacher.. God bless u always

  • @webdev10000hours
    @webdev10000hours 3 роки тому +2

    Hi Dr Parag,
    Another great video thanks!
    I have a question, it isn't directly related to Kotlin...at least not yet, but under the sphere of development none the less.
    Here's my scenario:
    I've got a large list of items (1000+) of which have relative attributes too.
    Upon user selection, I need to bring up the relevant item and attributes.
    What would be the most efficient way of storing and accessing this data?

  • @shekhargandham6857
    @shekhargandham6857 2 роки тому +2

    awesome teaching.

  • @codecinn7170
    @codecinn7170 Рік тому +1

    best free video that i found , learn a lot thx, underrated channel

  • @user-es2bp9td6z
    @user-es2bp9td6z 3 роки тому +3

    Thanks a lot Dr. for your lesson, please, if you can, do video in 1024 hd!!)) you really Doctor in Android programming, you are the best Teacher which i found in WWW

  • @quangpham7187
    @quangpham7187 3 роки тому +2

    As for me, I just say that thank you so much !!! My teacher ❤️❤️❤️. From VietNam.

    • @DrParagShukla
      @DrParagShukla  3 роки тому +1

      Glad you liked it.

    • @fucknamky
      @fucknamky Рік тому

      requery() giờ không được dùng nữa, có cách nào khác không bạn ?

  • @kskksk830
    @kskksk830 2 роки тому +2

    edName.setText() is not working for me. I am shy and you are the first person to whom I speak. because I find you very sympathetic and sincere. in this lesson you have shown extreme bravery ... bravo bravo bravo

    • @DrParagShukla
      @DrParagShukla  2 роки тому

      From Android Studio 4.1 Onwards in Android Kotlin
      If you get 'unresolved reference' on View then do the following
      open build.gradle file and add after all implementations this line:
      apply plugin: 'kotlin-android-extensions'
      then sync.

  • @maheshgharage8480
    @maheshgharage8480 2 роки тому +1

    Very simple and understandable flow of teaching.
    Thank you for laoding vedio 🙏

  • @nmbno479
    @nmbno479 Рік тому +1

    Extremly cool and clear video. Thank you so much Doc.

    • @DrParagShukla
      @DrParagShukla  Рік тому

      Glad that it helps
      My Pleasure

    • @fucknamky
      @fucknamky Рік тому

      requery() giờ không được dùng nữa, có cách nào khác không bạn ?

  • @osu_slave
    @osu_slave Рік тому

    is that video still actual now? i'm asking because i need to create app on kotlin+sqlite and other tutorials, that i've found, opens with a hundreds of errors and completely doesn't work(((
    there are several days before the practical work need to be completed, and I still have nothing and it doesn't work out because of errors, I'm in a panic ('deadline' - dec 19)

  • @mixitk97
    @mixitk97 2 роки тому +1

    You are the very best Sir.💯💯💯💯

  • @SajjadAli-hh9gq
    @SajjadAli-hh9gq 2 роки тому +1

    Excellent work, Sir

  • @pravinpund7523
    @pravinpund7523 3 роки тому

    Dear sir, Greetings of the day! I want to create an app which can extract data from excel, csv, xlsx formats and save into android sqlite database and then plot it in Mpandroid chart. If you could help me , please prepare series on it, in kotlin. Searched on youtube but couldn't find good tutorial. Thanks in advance.

  • @fucknamky
    @fucknamky Рік тому

    requery() is deprecated? 44:02
    Can you tell me, is there a way to replace requery() ?
    It took me 10 days to find the answer but I can't find it, I hope you can help me

  • @jagadhisshdeveloper1689
    @jagadhisshdeveloper1689 3 роки тому +1

    Please do a video on continues network checking wether network slow sir.

  • @kevinrea7820
    @kevinrea7820 11 місяців тому

    how could i have the listview on a separte activity screen ?

  • @dr.arpankumarraval8718
    @dr.arpankumarraval8718 2 роки тому +1

    Perfect Video Sir

  • @Sammednejkarandp
    @Sammednejkarandp 2 роки тому

    Excellent Sir!!!

  • @ghaithmuhammed279
    @ghaithmuhammed279 3 роки тому

    How can we add images with texts to project

  • @ghaithmuhammed279
    @ghaithmuhammed279 3 роки тому

    how can we add image view foe records

  • @ezzsakr
    @ezzsakr 2 роки тому +1

    very helpful, thank you very much.
    I have a question. If I have a database of 4 columns then how to configure the adapter? can we use "simple_list_item_multiple_choice"?

    • @DrParagShukla
      @DrParagShukla  2 роки тому +1

      Glad that it helps
      For data more than 2 columns you need to create custom layout adapter

  • @ankitshsharma
    @ankitshsharma Рік тому

    App is crashing after the use of following:
    Timings: 1:10:45
    val adapter = SimpleCursorAdapter(applicationContext, android.R.layout.simple_expandable_list_item_2, rs, arrayOf("Name", "Meaning"),
    intArrayOf(android.R.id.text1, android.R.id.text2), 0)
    listView.adapter = adapter
    What should I do now?

  • @Sammednejkarandp
    @Sammednejkarandp 2 роки тому

    Super!!

  • @paulatriep9279
    @paulatriep9279 Рік тому +1

    I am new to programming but have been ablecto follow this detailed app description. However synthetics has now been depecated and my app no longer works. I have read that binding needs to be used but I do not understand how this app will work. Can you please help.

    • @DrParagShukla
      @DrParagShukla  Рік тому

      From Android Studio 4.1 Onwards in Android Kotlin
      If you get 'unresolved reference' on View then do the following
      open build.gradle file and add after all implementations this line:
      apply plugin: 'kotlin-android-extensions'
      then sync.

  • @mitoban6844
    @mitoban6844 2 роки тому +1

    Sir.. How to insert date and time that came automatically with inserted data so that i know when the data is inserted??

    • @DrParagShukla
      @DrParagShukla  2 роки тому +1

      You can use Calendar to get the date and time. Just create one field in database and in insert function call the calendar to get current date time. And insert same in database.

  • @jean-paulzimmermann6366
    @jean-paulzimmermann6366 3 роки тому +1

    very simples it is!!! where do you find layout.simple_expandable_list_2???

  • @devendradhond8312
    @devendradhond8312 2 роки тому +1

    Sir which softwares download first for all these?

  • @dr.arpankumarraval8718
    @dr.arpankumarraval8718 2 роки тому +1

    Dear Sir,
    In new Version of Android bumblebee. The SimpleCursorAdapter is not showning any error and also not showing records in ListView. I request you to Share any video that shows other way to show all the records in ListView or RecyclerView.
    Thank you

  • @leandrosistemavs1043
    @leandrosistemavs1043 3 роки тому

    the code , please

  • @sunilnayak7939
    @sunilnayak7939 2 роки тому

    What a sexy explanation.. 😍
    Ek baar me samaj gaya

  • @maheshgharage8480
    @maheshgharage8480 2 роки тому +1

    While trying btinsert onclicklistner for adding a record
    rs.requery, requery showing deprecated
    What's the solution? Plz guide

    • @DrParagShukla
      @DrParagShukla  2 роки тому

      For that write
      rs = db.rawQuery(query, arg)

    • @maheshgharage8480
      @maheshgharage8480 2 роки тому

      @@DrParagShukla thanks🙏

    • @fucknamky
      @fucknamky Рік тому

      @@DrParagShukla I tried
      //rs.requery()
      rs = db.rawQuery("SELECT * FROM ACTABLE",null)
      but it's not working, help me

    • @fucknamky
      @fucknamky Рік тому

      @@maheshgharage8480 I tried
      //rs.requery()
      rs = db.rawQuery("SELECT * FROM ACTABLE",null)
      but it's not working, help me

  • @juanenriquez2798
    @juanenriquez2798 2 роки тому

    i can't find my package name on data > data > ?

  • @devendradhond8312
    @devendradhond8312 2 роки тому

    14:50 practical starts