Aditya Patil

Aditya Patil

  • NA
  • 535
  • 131k

SQLite Exception in WIndows Phone app in C#

Jul 23 2014 8:08 AM
XAML Code
<toolkit:DatePicker Name="dpkDate" Margin="0,144,0,332" />
            <toolkit:TimePicker Name="tpkDate" Margin="0,231,0,245" />
            <!--<toolkit:ListPicker x:Name="priority" Margin="10,321,10,100" ExpansionMode="ExpansionAllowed" Background="#FFF7EBEB" SelectedIndex="0">-->
            <ListBox HorizontalAlignment="Left" Height="103" VerticalAlignment="Top" Width="456" Name="priority" Margin="10,302,-10,0" >
                <ListBoxItem x:Name="high" Content="High" Foreground="White" FontSize="24"/>
                <ListBoxItem x:Name="medium" Content="Medium" Foreground="White" FontSize="24"/>
                <ListBoxItem x:Name="low" Content="Low" Foreground="White" FontSize="24"/>
            </ListBox>
            <!--</toolkit:ListPicker>-->
            <ListBox HorizontalAlignment="Left" Height="287" VerticalAlignment="Top" Width="456" Name="TaskListBox" Margin="10,302,-10,0" Visibility="Collapsed"/>
            <TextBox HorizontalAlignment="Left" Height="134" Margin="0,5,0,0" TextWrapping="Wrap" Text="Write Note" VerticalAlignment="Top" Width="456" Name="TextField"/>

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<Task>("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<Task>("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
{
/// <summary>
/// You can create an integer primary key and let the SQLite control it.
/// </summary>
[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.

Answers (7)