how to update sqlite database table in xamarin iOS

Question

How to updated sqlite db in xamarin iOS

Used the component SQLite.NET add to component.

I have inserted 10 records into db note.db which do have Table Student

 public class  Student{
    [Primary autoIncrement]
    public  int id {get;set;}
    public  int marks {get;set;}
    public  string grade {get;set;}
    public  string subject {get;set;}
  }

Records have been inserted into table.

I want to updated Marks of Student for xyz id;

var updateMarks = db.Query<Student>("UPDATE Student Set marks  = ? WHERE Stockid = ?",100,stdId);

for(var check in updateMarks)
Console.WriteLine ("AFter Updated {0}", check. marks);

SatanEnglish · Accepted Answer · 2014-10-03 00:37:35Z

4

Reading the Xamarin documentation the answer seems to be in that your NOT suppose to be doing a Query!

Execute – Use this method (and not Query ) when you don’t expect rows back from the SQL (such as INSERT, UPDATE and DELETE instructions).

This is on the page Part 3 - Using SQLite

So your updateMarks line would become =>

var updateMarks = db.Execute<Student>("UPDATE Student Set marks  = ? WHERE Stockid = ?",100,stdId);

Execute is the Key here

answered Oct 3, 2014 at 0:37

SatanEnglish

1,3661 gold badge13 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to update sqlite database table in xamarin iOS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related