How do I get around the “‘” problem in sqlite and c#?

by

The solution presented by Robert will work (i.e. replacing ' by '').

Alternatively you can use parameters as in:

DbCommand   cmd = new DbCommand();
DbParameter param = cmd.CreateParameter();
// ...
// more code
// ...
cmd.CommandText = "Insert table (field) values (@param)";
param.ParameterName = "param"
param.DbType = DbType.String;
param.Value  = @"This is a sample value with a single quote like this: '";
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();

More Related Contents:

  1. C# how to check if a string contains 3 times the same letters in a row [closed]
  2. How to trim after 1 letter from space C#? [closed]
  3. How would you count occurrences of a string (actually a char) within a string?
  4. How to convert UTF-8 byte[] to string
  5. How do I parse a string with a decimal point to a double?
  6. Splitting a string into chunks of a certain size
  7. Color different parts of a RichTextBox string
  8. What ‘additional configuration’ is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?
  9. How to access random item in list?
  10. How do I replace multiple spaces with a single space in C#?
  11. Convert int to string?
  12. Difference between string and StringBuilder in C#
  13. How to parse a string into a nullable int
  14. Compare version numbers without using split function
  15. How to convert DateTime to/from specific string format (both ways, e.g. given Format is “yyyyMMdd”)?
  16. String interning in .Net Framework – What are the benefits and when to use interning
  17. What is the best way to connect and use a sqlite database from C#
  18. “Templates can be used only with field access, property access, single-dimension array index, or single-parameter custom indexer expressions” error
  19. Write bytes to file
  20. Pick Random String From Array
  21. Java equivalent of C#’s verbatim strings with @
  22. How to create LINQ Query from string?
  23. How to convert string to integer in C#
  24. Converting a byte to a binary string in c#
  25. convert string array to string
  26. How can I safely convert a byte array into a string and back? [duplicate]
  27. A fast hash function for string in C#
  28. Does any one know of a faster method to do String.Split()?
  29. Is string actually an array of chars or does it just have an indexer?
  30. How do i replace accents (german) in .NET

Leave a Comment