Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 5th, 2012  |  syntax: None  |  size: 1.13 KB  |  hits: 17  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. How to insert and retrieve data from sqlite database with correct character set?
  2. SQLiteConnection cnn = new SQLiteConnection("Data Source=C:tempdatabase.s3db");
  3. cnn.Open();
  4. SQLiteCommand mycommand = new SQLiteCommand(cnn);
  5. mycommand.CommandText = "INSERT INTO images (image_name, tags, relevance) VALUES ("Example Image åäö.jpg", "test", 3)";
  6. mycommand.ExecuteNonQuery();
  7. cnn.Close();
  8. cnn.Dispose();
  9.        
  10. private IDbDataParameter AddParameter(IDbCommand command, string paramName, DbType type, object value)
  11. {
  12.     IDbDataParameter parameter = command.CreateParameter();
  13.     parameter.ParameterName = paramName;
  14.     parameter.DbType = type;
  15.     if (value != null)
  16.         parameter.Value = value;
  17.     else
  18.         parameter.Value = DBNull.Value;
  19.     command.Parameters.Add(parameter);
  20.     return parameter;
  21. }
  22.  
  23. mycommand.CommandText = "INSERT INTO images (image_name, tags, relevance) VALUES (@image_name, @tags, @relevance)";
  24. AddParameter(mycommand, "@image_name", DbType.String, "Example Image åäö.jpg");
  25. AddParameter(mycommand, "@tags", DbType.String, "Test");
  26. AddParameter(mycommand, "@relevance", DbType.Int32, 3);
  27. mycommand.ExecuteNonQuery();