Adding parameters in SQLite with C#
Try a different approach, naming your fields in the query and naming the parameters in the query:
this.command.CommandText = "INSERT INTO StringData (field1, field2) VALUES(@param1, @param2)";this.command.CommandType = CommandType.Text;this.command.Parameters.Add(new SQLiteParameter("@param1", data.Data));this.command.Parameters.Add(new SQLiteParameter("@param2", data.ByteIndex));...
var connectionstring = "Data Source=" + Environment.CurrentDirectory + "\\game.db";using (var connection = new SqliteConnection(connectionString)){ var insertCmd = connection.CreateCommand(); insertCmd.CommandText = "INSERT INTO Results(result, win) VALUES (@prizes, @win)"; insertCmd.Parameters.AddWithValue("prizes", prizes); insertCmd.Parameters.AddWithValue("win", winAmount); insertCmd.ExecuteNonQuery();}