SQLite error Insufficient parameters supplied to the command at Mono.Data.Sqlite.SqliteStatement.BindParameter SQLite error Insufficient parameters supplied to the command at Mono.Data.Sqlite.SqliteStatement.BindParameter sqlite sqlite

SQLite error Insufficient parameters supplied to the command at Mono.Data.Sqlite.SqliteStatement.BindParameter


Your spelling for @Category in INSERT statement is different from added parameter. You have:

command.Parameters.Add(new SqliteParameter("@Cateogry", ""));                                           ^^^^^^^^^^^                                           //@Category

Where it should be:

Modify your statement to:

command.Parameters.Add(new SqliteParameter("@Category", ""));


This has already been answered correctly, but I wish to add, for further information:

This specific SQLite error string can also be generated if any of the @Parameters are spelled differently in the INSERT statement vs the AddWithValue or .Add(new SqliteParameter... statements.