SQLite Exception in WIndows Phone app in C#

Aditya Patil

XAML Code












My Update Button Click C# Code to update SQLite Database
private void Update_Click(object sender, EventArgs e)
{
if(flag1==true)
{
try
{
// here we updating Notes i.e. Text Filed using Date filed. before that we have to check row present or not
var testdata = dbConn.Query("select * from task where Id='" + tempid + "'").FirstOrDefault();
// Check result is empty or not
if (testdata == null)
MessageBox.Show("ID Not Present in DataBase");
else
{
var tp = dbConn.Query("update task set Date= '" + dpkDate.Value.Value.ToShortDateString()
+ "' Time='" + tpkDate.Value.Value.ToShortTimeString() //SQLite Exception coming at this stage as per SQLITE Exception message
+ "' Text='" + TextField.Text
+ "' Priority='" + ((ListBoxItem)priority.SelectedItem).Content.ToString()
+ "' where Id = '" + id + "'").FirstOrDefault();

//Here unhandled exception
// Update Database
dbConn.Update(tp);
Update_List();
MessageBox.Show("Database Updated");
}
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
Task Class
public sealed class Task
{
///

/// You can create an integer primary key and let the SQLite control it.
///

[PrimaryKey, AutoIncrement]
public int Id { get; set; }

public String Date { get; set; }

public String Time { get; set; }

public string Text { get; set; }

public String Priority { get; set; }
}

Exception Messagebox Screenshot

Please solve my problem, may be syntax is wrong to set value of Time so please solve the time.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Maruthi12y ago
Accepted answer
can you try it with this

var tp = dbConn.Query("update task set Date= " + dpkDate.Value.Value.ToShortDateString()
+ ," Time=" + tpkDate.Value.Value.ToShortTimeString()
+, " Text=" + TextField.Text
+, " Priority=" + ((ListBoxItem)priority.SelectedItem).Content.ToString()
+ ," where Id = " + id + "'").FirstOrDefault();
Aditya Patil12y ago
Problem solved,

As where I used my old null variable so its not getting updated now its solved with my updated variable.
Thankx
Aditya Patil12y ago
http://www.c-sharpcorner.com/Forums/Thread/262468/database-not-updating-by-update-query-sqlite.aspx
Please look to this problem too
Ramesh Maruthi12y ago
cool Aditya good to hear your problem solved :)
Aditya Patil12y ago
Ohh you added , in between
var tp = dbConn.Query("update task set Date= '" + dpkDate.Value.Value.ToShortDateString()
                                + "', Time='" + tpkDate.Value.Value.ToShortTimeString() //SQLite Exception coming at this stage as per SQLITE Exception message
                                + "', Text='" + TextField.Text
                                + "', Priority='" + ((ListBoxItem)priority.SelectedItem).Content.ToString()
                                + "' where Id = '" + id + "'").FirstOrDefault();

Its worked now. I think.
Ramesh Maruthi12y ago
Aditya,

please see the difference i emitted the single quotes and added the comma after every column give a try in that way
Aditya Patil12y ago
I written the same code, see above, Getting same exception.
How I can solve this?