// 连接字符串 data source=d:\testdb3;password=1234
SQLiteConnectionStringBuilder connStr = new SQLiteConnectionStringBuilder();
connStrDataSource = @"d:\testdb3";
connStrPassword = "1234";
conn = new SQLiteConnection(connStrToString());
connOpen();
// 插入数据
string SQL = "INSERT INTO test(k) VALUES(:k)";
SQLiteCommand cmd = connCreateCommand();
cmdCommandText = SQL;
FileStream picStream = FileOpenRead(@"d:\1bmp");
byte[] bArray = new byte[picStreamLength];
picStreamRead(bArray, 0, bArrayLength);
picStreamClose();
cmdParametersAdd("k", DbTypeBinary)Value = bArray; // BLOB
cmdExecuteNonQuery();
//取出数据
cmdCommandText = "SELECT k FROM test";
SystemDataSQLiteSQLiteDataReader reader = cmdExecuteReader();
while (readerRead())
{
MemoryStream streamImage = new MemoryStream(reader["k"] as byte[]);
pictureBox1Image = ImageFromStream(streamImage);
streamImageClose(); // 关闭流
}
readerclose();
connclose();
选择开始菜单中→程序→Management SQL Server 2008→SQL Server Management Studio命令,打开SQL Server Management Studio窗口,并使用Windows或 SQL Server身份验证建立连接。
以上就是关于请教SQLite数据库读写BLOB字段全部的内容,包括:请教SQLite数据库读写BLOB字段、如何使用Hadoop读写数据库、等相关内容解答,如果想了解更多相关内容,可以关注我们,你们的支持是我们更新的动力!
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)