c 将图片存入mysql_c#读取图像保存到数据库中(数据库保存图片)

注:MyTools.g_PhotoField为数据库表中的图象字段名称

//将图片保存到数据库中

if(this.picPhoto.Image==null)

{

m_DataRow[MyTools.g_PhotoField]=DBNull.Value;

}

else

{

try

{

MemoryStream ms = new MemoryStream ();

picPhoto.Image.Save (ms,System.Drawing.Imaging.ImageFormat.Bmp);

byte [] myData = new Byte [ms.Length ];

ms.Position = 0;

ms.Read (myData,Convert.ToInt32 (ms.Length ));

m_DataRow[MyTools.g_PhotoField] = myData;

}

catch(System.Exception ee)

{

MessageBox.Show(ee.Message);

}

}//else

//读取图象

if(this.m_DataRow[MyTools.g_PhotoField]!=DBNull.Value)

{

try

{

Byte[] byteBLOBData =  new Byte[0];

byteBLOBData = (Byte[])m_DataRow[MyTools.g_PhotoField];

MemoryStream stmBLOBData = new MemoryStream(byteBLOBData);

this.picPhoto.Image= Image.FromStream(stmBLOBData);

}

catch(Exception ex)

{

MessageBox.Show(ex.Message);

}

}

else

{

this.picPhoto.Image= null;

}