SQLiteConnectionStringBuilder connStr =
new
SQLiteConnectionStringBuilder();
connStr.DataSource =
@"d:\test.db3"
;
connStr.Password =
"1234"
;
conn =
new
SQLiteConnection(connStr.ToString());
conn.Open();
string
SQL =
"INSERT INTO test(k) VALUES(:k)"
;
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = SQL;
FileStream picStream = File.OpenRead(
@"d:\1.bmp"
);
byte
[] bArray =
new
byte
[picStream.Length];
picStream.Read(bArray, 0, bArray.Length);
picStream.Close();
cmd.Parameters.Add(
"k"
, DbType.Binary).Value = bArray;
cmd.ExecuteNonQuery();
cmd.CommandText =
"SELECT k FROM test"
;
System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader();
while
(reader.Read())
{
MemoryStream streamImage =
new
MemoryStream(reader[
"k"
]
as
byte
[]);
pictureBox1.Image = Image.FromStream(streamImage);
streamImage.Close();
}
reader.close();
conn.close();