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