dimanche 3 mai 2015

saving listview into SQLite database - unhandled exception

I need help saving listview into a SQLite database, using this to implement the libraries.

Using Finisar.SQLite;

However, evyritme I try to save the database, I get this error while sql_cmd.ExecuteNonQuery(); is highlighted.

An unhandled exception of type 'Finisar.SQLite.SQLiteException' occurred in SQLite.NET.dll

Additional information: near "modified": syntax error

Code:

private void writeResultsButton_Click(object sender, EventArgs e)
    {
    sql_con = new SQLiteConnection("Data Source=DemoT.db;Version=3;New=True;Compress=True;");

    sql_cmd = sql_con.CreateCommand();

    sql_cmd.Connection.Open();

    foreach(ListViewItem item in resultsList.Items)

    {

   sql_cmd.Parameters.Add("@path","value1");

   sql_cmd.Parameters.Add("@size","value2");

   sql_cmd.Parameters.Add("@last modified","value3");

   sql_cmd.CommandText = "Insert Into Log(Path,Size,Last modified) Values (@path,@size,@last modified)";

   sql_cmd.ExecuteNonQuery();

    }



    sql_cmd.Connection.Close();

    sql_cmd.Dispose();
    }

Thanks in advance!

Aucun commentaire:

Enregistrer un commentaire