Adding parameters in SQLite with C#

by

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));
...

More Related Contents:

  1. What ‘additional configuration’ is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?
  2. SQLite Database Locked exception
  3. SQLite Insert very slow?
  4. Create SQLite Database and table
  5. Create/Use User-defined functions in System.Data.SQLite?
  6. SQLite keeps the database locked even after the connection is closed
  7. How does the SQLite Entity Framework 6 provider handle Guids?
  8. In sqlite I would do, But how in mongodb c#
  9. Unable to load DLL ‘SQLite.Interop.dll’
  10. Password Protect a SQLite DB. Is it possible?
  11. Is there a .NET/C# wrapper for SQLite? [closed]
  12. How do I get around the “‘” problem in sqlite and c#?
  13. auto create database in Entity Framework Core
  14. Problems using Entity Framework 6 and SQLite
  15. SQLite .NET performance, how to speed up things?
  16. What is the best way to connect and use a sqlite database from C#
  17. Getting the Last Insert ID with SQLite.NET in C#
  18. How to auto create database on first run?
  19. Enabling Foreign key constraints in SQLite
  20. Options for using System.Data.SQLite in a 32bit and 64bit C# world
  21. Unable to find the requested .Net Framework Data Provider – SQLite
  22. Visual Studio C# – SQLite.Interop.dll not found
  23. Problem using SQLite :memory: with NHibernate
  24. Encrypt SQLite database in C#
  25. How to create a password protected database?
  26. SHA1 hashing in SQLite: how?
  27. How to access random item in list?
  28. SelectSingleNode returns null when tag contains xmlNamespace
  29. Getting “type or namespace name could not be found” but everything seems ok?
  30. Serializing a Nullable in to XML

Leave a Comment