在MySQL数据库中,有一种blob数据类型,用来存储文件。C#编程语言操作MySQL数据库需要使用MySQL官方组件MySQL.Data.dll。
现在说一说如何实现blob类型数据的操作:
写入数据库:
FileStream f1 = new FileStream(FileName1, FileMode.Open);
byte[] codeBuf = new byte[f1.Length];
fsCode.Read(codeBuf, 0, codeBuf.Length);
FileStream f2 = new FileStream(FileName2, FileMode.Open);
byte[] Buf = new byte[f2.Length];
fsPar.Read(Buf, 0, Buf.Length);
MySqlConnection dbConn = new MySqlConnection("server=localhost;user id=db_user;password=123456;database=dbtest;SslMode = none;");
dbConn.Open();
if (dbConn.State == ConnectionState.Open)
{
MySqlCommand sqlCommand = new MySqlCommand();
sqlCommand.Connection = dbConn;