方法：C#在WinForm中如何将Image存入SQL2000和取出显示

最新推荐文章于 2024-09-14 19:55:29 发布

auam58446

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量121

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/RoadGY/archive/2010/05/22/1741309.html

版权

//保存
sql="insert into p_ry_photo(id,photo) values ('"+id+"',@i)";
SqlCommand cmd=new SqlCommand(sql,CommonVar.SqlConDataBase);
MemoryStream s = new MemoryStream();
picPhoto.Image.Save(s,System.Drawing.Imaging.ImageFormat.Jpeg);
byte[] b = s.ToArray();
s.Close();
cmd.Parameters.Add("@i",SqlDbType.Image,(int)b.Length);
cmd.Parameters["@i"].Value=b;
cmd.ExecuteNonQuery();

//读取图象

private void Readphoto(string id)
{
try
{
string ls_sql="select photo from p_ry_photo where id='"+id+"'";
this.picPhoto.Image=null;
this.picPhoto.Refresh();
SqlCommand cmd=new SqlCommand(ls_sql,CommonVar.SqlConDataBase);
SqlDataReader reader=cmd.ExecuteReader();
while(reader.Read())
{
byte[] b = (byte[])reader[0];
MemoryStream s = new MemoryStream(b);
Bitmap bmp = new Bitmap(s);
System.Drawing.Image image = bmp;
picPhoto.Image = image;
s.Close();
}
reader.Close();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}