C# MySQL 图片的存储与读取

C#MySQL图片的存储与读取

一、存储图片

privatevoidbutton3_Click(objectnder,EventArg)

{

if(!=null)

{

//将图片对象image转换成缓冲流imageStream

MemoryStreamimageStream=newMemoryStream();

(imageStream,

);

//获得图片的字节数组imageByte

byte[]imageByte=fer();

//建立数据库连接

MySqlConnection

();

//设置命令参数

stringinrtStr="inrtintoimg(image)values(?imageByte)";

MySqlCommandcomm=newMySqlCommand();

tion=conn;

dText=inrtStr;

dType=;

//设置数据库字段类型MediumBlob的值为图片字节数组imageByte

(new

Blob)).Value=imageByte;

//执行命令

try

{

eNonQuery();

}

catch(Exceptionex)

{

(ng());

}

e();

();

e();

}

}

MySqlParameter("?imageByte",

conn=new

MySqlConnection("Server=localhost;Uid=root;Password=123;Databa=test");

二、读取图片

privatevoidbutton4_Click(objectnder,EventArg)

{

//建立数据库连接

MySqlConnection

();

//设置命令参数

MySqlCommandcomm=newMySqlCommand("lectimagefromimgorderbyiddesc",

conn);

//执行命令并获得数据读取器

MySqlDataReaderdr=eReader();

if(())

{

//读出图片字节数组至byte[]

byte[]imageByte=newbyte[es(0,0,null,0,ue)];

es(0,0,imageByte,0,);

//将图片字节数组加载入缓冲流

MemoryStreamimageStream=newMemoryStream(imageByte);

//从缓冲流生成图片

Imageimage=ream(imageStream,true);

=image;

}

e();

e();

();

e();

}

conn=new

MySqlConnection("Server=localhost;Uid=root;Password=123;Databa=test");