
Untitled
By: a guest on
May 5th, 2012 | syntax:
None | size: 1.13 KB | hits: 17 | expires: Never
How to insert and retrieve data from sqlite database with correct character set?
SQLiteConnection cnn = new SQLiteConnection("Data Source=C:tempdatabase.s3db");
cnn.Open();
SQLiteCommand mycommand = new SQLiteCommand(cnn);
mycommand.CommandText = "INSERT INTO images (image_name, tags, relevance) VALUES ("Example Image åäö.jpg", "test", 3)";
mycommand.ExecuteNonQuery();
cnn.Close();
cnn.Dispose();
private IDbDataParameter AddParameter(IDbCommand command, string paramName, DbType type, object value)
{
IDbDataParameter parameter = command.CreateParameter();
parameter.ParameterName = paramName;
parameter.DbType = type;
if (value != null)
parameter.Value = value;
else
parameter.Value = DBNull.Value;
command.Parameters.Add(parameter);
return parameter;
}
mycommand.CommandText = "INSERT INTO images (image_name, tags, relevance) VALUES (@image_name, @tags, @relevance)";
AddParameter(mycommand, "@image_name", DbType.String, "Example Image åäö.jpg");
AddParameter(mycommand, "@tags", DbType.String, "Test");
AddParameter(mycommand, "@relevance", DbType.Int32, 3);
mycommand.ExecuteNonQuery();