44 COMMENTS

1. 

   Arief Yudhawarman Posted on July 9, 2020 at 12:19 am

   I suggest function updateData like below, it returns integer.
   public int updateData (String id, String name, String surname, String marks) {
   db = this.getWritableDatabase();
   ContentValues contentValues = new ContentValues();
   contentValues.put(COL_1, id);
   contentValues.put(COL_2, name);
   contentValues.put(COL_3, surname);
   contentValues.put(COL_4, marks);
   String[] IDs = {id};
   return db.update(TBL_NAME, contentValues,"ID = ?",IDs); // successfull return 1 else return 0
   }
   Then on the calling method
   …
   if (isUpdate == 1)
   Toast.makeText(MainActivity.this, "Data updated.", Toast.LENGTH_LONG).show();
   else
   Toast.makeText(MainActivity.this, "ID not found.nData not updated.", Toast.LENGTH_LONG).show();
   So if update succesfull the function updateData will return 1 else 0.

   Reply
2. 

   Kumar Rangaraj Posted on July 9, 2020 at 12:19 am

   Good example. However there is a bug in code.
   As is code in class DatabaseHelper.java =>
   public boolean updateData(…
   …etc..

   db.update(TABLE_NAME, contentValues, "ID = ?",new String[] { id });
   return true;

   To be code in class DatabaseHelper.java =>
   public boolean updateData(…
   …etc..

   int lint =
   db.update(TABLE_NAME, contentValues, COL_1 + " = ?", new String[]{id});

   if (lint == 0) return false;
   else return true;

   Reply
3. 

   עמית שלו Posted on July 9, 2020 at 12:19 am

   bro ty so much!

   Reply
4. 

   Assertor Posted on July 9, 2020 at 12:19 am

   The update doesn't work properly in case wrong id is inserted. It still shows updated successfully. To solve this, take result of db.update() in an int variable. Compare this value with 0, if it is greater than 0 return true else return false.

   Reply
5. 

   VA coder Posted on July 9, 2020 at 12:19 am

   It says array dimension missing

   Reply
6. 

   Akshay Jain Posted on July 9, 2020 at 12:19 am

   thank you very much .. cool stuff there , i have question that why did you pass only id in string[ ] , why not all(name , surname etc) … i didn't get this

   Reply
7. 

   Saurabh Jayswal Posted on July 9, 2020 at 12:19 am

   can u make videos on where query is applied for viewing data

   Reply
8. 

   sainath sai Posted on July 9, 2020 at 12:19 am

   can any reply plzzzzzz

   Reply
9. 

   sainath sai Posted on July 9, 2020 at 12:19 am

   can any give mw rply???

   Reply
10. 

    sainath sai Posted on July 9, 2020 at 12:19 am

    is any one there to help me out ??

    Reply
11. 

    sainath sai Posted on July 9, 2020 at 12:19 am

    Hai this is sainath can any one help me insert,Update and delete data in mssql database using android studio can any one reply me plzzz….

    Reply
12. 

    Parikshit Raghav Posted on July 9, 2020 at 12:19 am

    Thanks for sharing your knowledge with us. May God bless you man.

    Reply
13. 

    Saman Ariya Posted on July 9, 2020 at 12:19 am

    this guy is sexy af 😀

    Reply
14. 

    Brian Ramírez Posted on July 9, 2020 at 12:19 am

    man you are my hero.

    Reply
15. 

    Ricardo W. Posted on July 9, 2020 at 12:19 am

    Thanks again!

    Reply
16. 

    វិចិត្រព្រីនខ្នាតធំ Posted on July 9, 2020 at 12:19 am

    It's working. Thanks

    Reply
17. 

    Macky Davin Paragas Posted on July 9, 2020 at 12:19 am

    Help, when i initialize my updataData to oncreate and start running the app it always shuts down :/

    Reply
18. 

    Tefera Mngesha Posted on July 9, 2020 at 12:19 am

    Hi parogrammingKnowledge thank you very much for your video tutorial.I was appreciate if you could make in video call and in SMS messaging application. thank you again.

    Reply
19. 

    quieromicubita Posted on July 9, 2020 at 12:19 am

    Thanks for this super clear tutorial

    Reply
20. 

    Jose Georges Posted on July 9, 2020 at 12:19 am

    just one question, when I put an ID that is not on my table, even though it does not update it still sends me "Data Updated Successfully", what would be the reason of this?

    Reply
21. 

    Boris Kunda Posted on July 9, 2020 at 12:19 am

    data is not updating only showing toast message …..need help

    Reply
22. 

    alberto cassio Posted on July 9, 2020 at 12:19 am

    I would like to display data on a list view rather than a message from string buffer. Could you please show me how ?

    Reply
23. 

    Swathi Karkodlu Posted on July 9, 2020 at 12:19 am

    thank you..sir..
    very informative lecturing

    Reply
24. 

    darkman237 Posted on July 9, 2020 at 12:19 am

    So what happens if someone types in the wrong id?

    Reply
25. 

    darkman237 Posted on July 9, 2020 at 12:19 am

    How would you be able to view all and tap the one you want to change or delete?

    Reply
26. 

    Samii Posted on July 9, 2020 at 12:19 am

    respected sir i have a request that sir the tutorial vidio are not so much clear pic we don't understand that what coding is done sir please give me some suggestion that what i do sir i well be very thinkful of you sir

    Reply
27. 

    Tabai smida Posted on July 9, 2020 at 12:19 am

    Can U help me please with that… !!!
    android.database.sqlite.SQLiteException: no such column: ID (code 1): , while compiling: UPDATE student_table SET ID=?,NAME=?,SURNAME=?,MARKS=? WHERE ID= ?

    Reply
28. 

    Giovanni Ciavarelli Posted on July 9, 2020 at 12:19 am

    Hello! Thank you for this tutorial … I need to update a single value on a specific row … how could I do? Thanks!

    Reply
29. 

    TheHumanBeingofEarth Posted on July 9, 2020 at 12:19 am

    variable isUpdate will always have the value true because u have forced the method to return true, so by default, it is going to always return true even if the update is successful or not. Seems like, in that case, using Toast will confuse rather than helping with a message. You need to fix ur method.

    Reply
30. 

    Harjinder singh Posted on July 9, 2020 at 12:19 am

    @ProgrammingKnowledge can you tell me how to store image in SQLite Database

    Reply
31. 

    alfadhan sheik Posted on July 9, 2020 at 12:19 am

    data is not updating only showing toast message …..need help

    Reply
32. 

    Aryan vedh Posted on July 9, 2020 at 12:19 am

    Hi ProgrammingKnowledge, Thank you very much for amazing Tutorial. I was wondering, if you could make tutorial on bottom bar? I tried to look for tutorials, but some how they dont work when applied in my app, I will really appreciate it 🙂

    Thank you 🙂

    Reply
33. 

    jesus king Posted on July 9, 2020 at 12:19 am

    i got this error:

    FATAL EXCEPTION: main
    Process: com.example.jesusalvelo.sqlite, PID: 2438
    android.database.sqlite.SQLiteException: near "fromstudent_table": syntax error (code 1): , while compiling: select * fromstudent_table

    could it be this part?
    public Cursor getAllData(){
    SQLiteDatabase db = this.getWritableDatabase();
    Cursor res = db.rawQuery("select * from"+TABLE_NAME,null);
    return res;
    }

    Reply
34. 

    Keith Au Posted on July 9, 2020 at 12:19 am

    Yeah@@@Thanks for your generous to show such a complicated Sql lite building process and learned a lot@@@

    Reply
35. 

    kalyan srinivas Posted on July 9, 2020 at 12:19 am

    How to send those .db files to an HTTP server?

    Reply
36. 

    Jonathan Langford Posted on July 9, 2020 at 12:19 am

    Thank you so much

    Reply
37. 

    shubham raja Posted on July 9, 2020 at 12:19 am

    update not successful but still give messege that updated successfully

    Reply
38. 

    Bereshyit Bara Posted on July 9, 2020 at 12:19 am

    AS 2.2.1 is so awesome and powerful that following source codes are given automatically:
    public Cursor getAllData() {
    SQLiteDatabase db = this.getWritableDatabase();
    Cursor res = db.rawQuery("select * from "+TABLE_NAME,null);
    return res;
    }

    public boolean updateData(String id,String name,String surname,String marks) {
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues contentValues = new ContentValues();
    contentValues.put(COL_1,id);
    contentValues.put(COL_2,name);
    contentValues.put(COL_3,surname);
    contentValues.put(COL_4,marks);
    db.update(TABLE_NAME, contentValues, "ID = ?",new String[] { id });
    return true;

    Reply
39. 

    giang huong Posted on July 9, 2020 at 12:19 am

    Tutoria code backup name, Surname & marks in updaite SQLite

    Reply
40. 

    giang huong Posted on July 9, 2020 at 12:19 am

    Tutoria backup name, Surname & marks in updaite

    Reply
41. 

    giang huong Posted on July 9, 2020 at 12:19 am

    Tutoria backup name, Surname & marks in updaite

    Reply
42. 

    Shoaib Ahmed Posted on July 9, 2020 at 12:19 am

    You are really good, please come up with more advance concepts like android Material Design and motions

    Reply
43. 

    Tweheyo Ivan Posted on July 9, 2020 at 12:19 am

    thanks for your gud tutorials on sqlite ….ts awesome

    Reply
44. 

    Aditya Kulkarni Posted on July 9, 2020 at 12:19 am

    My emulator does not start and neither my mobile is root so i cant see the table. Is there another way to see the table? Please help me.

    Reply