Android SQLite Database Tutorial 5 # Update values in SQLite Database table using Android

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.

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;

bro ty so much!

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.

It says array dimension missing

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

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

can any reply plzzzzzz

can any give mw rply???

is any one there to help me out ??

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….

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

this guy is sexy af 😀

man you are my hero.

Thanks again!

It's working. Thanks

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

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.

Thanks for this super clear tutorial

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?

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

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

thank you..sir..
very informative lecturing

So what happens if someone types in the wrong id?

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

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

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= ?

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

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.

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

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

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 🙂

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;
}

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

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

Thank you so much

update not successful but still give messege that updated successfully

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;

Tutoria code backup name, Surname & marks in updaite SQLite

Tutoria backup name, Surname & marks in updaite

Tutoria backup name, Surname & marks in updaite

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

thanks for your gud tutorials on sqlite ….ts awesome

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.